In order to run this tech tip you need following things:(a) VB5 or VB6(b) Reference to Type Lib information object component (TLIBINF32.dll). This function takes in the name of the

If a run-time statement error (such as a constraint violation) occurs in a batch, the default behavior in SQL Server is to roll back only the statement that generated the

The Windows shell provides a simple way to detect whether a given folder is shared or not. You must call the SHGetFileInfo() API function and analyze the way it fills

Not all programs may run on all the Windows platforms. Often programs require at least a certain version of Windows. In most cases, this is due to the lack of

If you ever needed to programmatically enable your users to search for files, you certainly found useful the possibility of reusing the system Find dialog integrated in the Start menu

Even if we’re living in a 32-bit world, and closer and closer to the 64-bit day, 16-bit programs are still running out there. Knowing whether a given EXE is 32-bit

NOTE that this tip requires Windows 98, Windows 2000, Windows 95/NT 4.0 + Active Desktop.If your application must do a lot of work with Office documents, then chances are that

In most cases, you can use CoCreateInstance and forget about CoGetClassObject.Function CoGetClassObject returns the pointer to the desired component’s classfactory and not the component itself. The desired component is created

Unicode characters use more storage space than characters in a regular SQLServer character set use. A regular SQL Server character set is a single-byte set that supports up to 256

Error messages should be passed on to users so that they are always aware of the problems they have encountered and will perform the requested actions. Although you cannot use

By default, all static variables, structs and arrays are automatically initialized to binary zeros before program’s outset. Likewise, static objects are initialized to binary zeros before their constructor is activated.

Although the string class is very convenient for most string manipulation operations, it may be necessary sometimes to copy the contents of a string to a different container, e.g., in

If you don’t want users to navigate to another URL when they click on a HTML link in an anchor tag, you need to create a Null HTML link in

Sometimes it’s useful to trap the right click over controls such as CommandButton. Unfortunately, the Click event only fires for left button clicks. The MouseDown and MouseUp events fire for

Prior to VB5, when you wanted to make a form appear on top of another form, you either made it modal or used an MDIForm with children. If you wanted

To prevent losing the ability to maintain binary compatibility with compiled object code, take the first compiled build and move it into a separate directory, then tell VB to maintain

The typical method of validating multiple expressions is to string together a series of If statements separated with an equal number of And statements. Shorten that process by passing one

If you need to get a Web page visitor’s IP address in your ASP script, it

Variables and objects defined within a namespace have static storage type. As such, namespace members are by default initialized to binary zeros before program’s outset. Likewise, namespace members are destroyed

In JavaScript, it is easy to ask the user to confirm an action by using JavaScript Confirm () function. Say you have a function NavigateToWebAddress() (which needs confirmation from the

You can allocate a multi-dimensional array dynamically, as in this example: int*pp[10]; //an array of ten pointers for (int j=0; j

To print the entire document from JavaScript, use parent.print() in the code. For example, this code snippet can be used to print the entire document on click event.

A pure function should never be invoked. However, a buggy program or a buggy compiler can sometimes call a pure virtual function. In general, when a pure virtual function is

There are many ways you can code to create a back link. One of the quick and easy ways to do this is with JavaScript history object. The code snippet

If you set a form’s KeyPreview property to True, all keystrokes for items on that form first trigger the form’s events. This makes it easy to do form-level filtering and

Sometimes you might find it important to know where your site visitors came from. You can then customize your ASP in a certain way, or you know how much your

The communication between the COM client and server can happen in three ways: the vtble interface, dispinterface, or dual interface. The COM client can communicate with the server through IDispatch

In Visual InterDev, you can have more than one view (Project Explorer, Properties, Data, Script Outline, Output, Find, Toolbox, etc) in a docked window. If you have too many of

For an in-proc COM component, a vtbl interface is generally in the order of 100 times faster than a dispinterface (although it depends on type of arguments in the function).

To use the ADO constants, you’ve probably added this piece of code to each of your ASPs: If you write reusable data access ASP code, you might have seen the