Question: I want to show my users when a record was last updated. Is there any way to display the timestamp field? Answer: The timestamp field is not a good

Question: How do I take a SQL 6.5 database that is residing on one machine and move the entire database to another machine? Answer: I have three methods for you

Question: I’m running Windows NT 4.0 (Service Pack 3) and have developed an ActiveX Server (EXE) using Visual Basic 6 (Service Pack 3). How come whenever I try to create

Question: I have scoured the Web and can’t find any information on where to obtain BIOS version/name information. As far as I can tell, there are no APIs or C

Question: From the code below, I get output: ‘asdf’ which is correct. But when the VB program is closed, it says VB6 has preformed an illegal operaton and will be

After upgrading your system to FrontPage 2000, you may get an error message when you try to run the FrontPage Server Administrator from the Windows NT Option Pack group. The

It is useful to follow these guidelines when you develop COM components that need to talk to VB. 1. Only use VARIANT data types in your interface . Although VB

Because GUID are 16 bytes in size, you don’t want to pass them by value. Instead, you should pass them by reference. This is why Queryinterface takes a constant reference.

You can experience a great increase in database performance if you utilize connection pooling. Creating a connection to a database takes a lot of time and resources. If every you

‘ the name of a control given the corresponding VBControl object’ (accounts for items in control arrays)Function VBControlName(vbc As VBIDE.VBControl) As String Dim index As Long index = vbc.Properties(“Index”) If

‘ Returns the nesting level of a TreeView’s Node object’ (returns zero for root nodes.)Function NodeNestingLevel(ByVal Node As Node) As Integer Do Until (Node.Parent Is Nothing) NodeNestingLevel = NodeNestingLevel +

Every now and then you need to fill a TreeView control with some random data, for example when you want to test a routine and you don’t want to write

‘ Convert to uppercase, lowercase, or propercase the text that is’ currently selected in the active code windowSub ConvertSelectedText(VBInstance As VBIDE.VBE, Optional conversion As Long = _ vbUpperCase) Dim startLine

‘ Returns a value >0 if Node1 is a parent (or grandparent) of Node2’ Returns a value

Internet Information Server (IIS), by default, uses an apartment-threaded, or single-threaded, threading model. This design choice was made because many Web sites still used Access as the database backend. Access,

What is wrong with this code snippet? #include #include using std::string;using std::list;class Node {/*..*/};int main(){ list ln; //error} If you try to compile this example, your compiler will issue numerous

When a long line of a quoted string has to be broken, you can use the line continuation marker as described in the tip Use the Continuation Marker Before a

The java.util.Random class has a public int nextInt() method that returns a randomly selected integer, but there is no innate method in that class to create a random number over

Many implementations still do not support exception handling very well. Therefore, you can implement, using global variables and passing a parameter to the constructor, instead. However, on implementations that support

Constructors have no return value (not even void). Therefore, you have to use alternative techniques of reporting errors during object’s construction. There are three common techniques of reporting such errors.

This function is useful for returning a portion of a string between two points in the string. You could, for example, extract a range name returned by Excel found between

The typical way of entering user-specified data into a list box is one entry at a time; however, you can accept multiple delimited entries at once and add them to

A simple loop through your main string lets you count the occurrences of a specified character or string. This function is useful for determining if enough commas appear in your

Using global flags to indicate runtime errors has many disadvantages: Global variables are problematic in multithreaded environments. In addition, programmers might forget to test the value of the global error

The typical way of entering user-specified data into a list box is one entry at a time; however, you can accept multiple delimited entries at once and add them to

When SQL Server 7.0 uses memory dynamically, it queries the system periodically to determine the amount of free physical memory available. Though this configuration is recommended, you can still set

The IntelliSense feature of Visual InterDev is very handy, but it may induce you to add bugs to your code. For example, when you are using a recordset object’s Open