Use of inequality operators in SQL queries force databases to use table scans to evaluate the inequalities. These queries generate high I/O if they run regularly against large tables. You

It has become customary for Microsoft Windows users to close an active window by pressing the escape key. It is not that easy to intercept key events in Java. This

When you use Access database or other file based database with Active Server Pages (ASP), you should make sure that the directory in which the database resides is marked as

Question: When I build a VFP executable file and copy it to another machine, I cannot seem to run the executable. I obtain messages like “cannot …..file support library.” What

Question: How do I use a memory variable as a filename when copying and renaming a file? Answer: For sake of example, let’s say that you have a character variable

Question: How do I create threads in PowerBuilder? Answer: You can create separate threads in PowerBuilder by using the Shared Object features of PowerBuilder. Although this feature was initially created

Question: How can I determine a length of a PB structure? Answer: There is no way in PowerBuilder to do this. If you require the size of the structure for

Question: When linking to the FoxPro tables from Access 97 I see the tables, but when I double-click on the tables I get #ERROR in every field. Can you please

Question: Is there any way that pictures of users can be downloaded into the system so that when you pull up their name and select “Properties” you can get a

Question: Is there a server-side method to disallow Exchange users from auto-forwarding to external e-mail providers for personal use, especially when they leave the company? Answer: Yes there is. On

Question: I’m trying to create a drop-down sub menu in a VB form. I’ve tried almost every applicable API32 call and have not been able to do it. Answer: If

Question: I have a datawindow where I sort the data by clicking on the column header. In one of the columns I have a drop-down datawindow attached. Whenever I click

Question: I am planning to give my Microsoft Certification Exam for VB 6.0 (Developing Distributed Application Development using Visual Basic 6.0 (70-175)). I have worked on Visual Basic for 6

Question: Using ifstream, I want to open a file that already exists, and launch an error message if it does not exist. How can I get indication that the file

Question: Is there any way I can create scrollable forms in VB 5.0? Answer: There isn’t a simple way that I know of. If you must have scrollable screens consider

Question: Is there a compiler or run-time option to specify whether to use static binding or dynamic binding for function calls? This option, if it exists, may actually override the

Question: How to write a text directly to printer port, such as lpt1? Answer: While there is no standard method of writing directly to a printer, you can try writing

If you have to handle a form with multiple SUBMIT buttons on it, you can find which button was clicked by looking at the button’s value attribute in the Request.Form

If you’re developing a VB database application, you’re probably using a DSN (data source name) because it makes the access to your database file easier. Of course, when you distribuite

If you want to create an ADO Command using VB code, remember to always set the CommandType property to the appropriate adCmdxxxx constant value. If you don’t this, will be

You’re probably aware that most VB functions don’t work well with Null values, which is an issue when you’re working with database columns that can accept Nulls. For example, the

If you want to draw user’s attention but you don’t want to force the form to move to the foreground, you can simply flash its caption (and its icon in

If you’re displaying a long string, which contains line feeds and carriage returns, then replace those ASCII characters with something that will format the string before displaying the same to

A reader tried to declare a template as a virtual member function of a class. However, his compiler refused to compile the code. The reader wanted to know what he

Many C compilers provide a non-standard feature called “structured exception handling”, or SEH for short. SEH can trap asynchronous, platform-specific exceptions such as division by zero, floating point overflow and

You should always prefer to use one language in your Web pages.When you use both VBScript and JavaScript on the same page, bothscript engines are loaded into memory. Simply rewriting

The SQL Server 7.0 automatically recalculates the table’s distribution statistics when the number of changes reaches some predefined values. This automatic recalculation of the distribution statistics can cause problems such

Java Database Connectivity (JDBC) is an API that enables Java developers to access any tabular data source (e.g relational databases) from Java code. The API comes as a set of

Editor’s Note:This text has changed from the original version. Have you ever needed toconvert a byte array (byte []) into a displayable hex string? The JDK does notprovide this capability

The argument type of a function template is normally deduced automatically. For example: int n = max (5,10); /* max deduced because 5 and 10 are of type int */