‘ 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

Even with better tools, sometimes you still have to use the good old Response.Write to print out debug statements to your ASP. The downside to this technique is that you

The RETURN keyword lets you exit from a T-SQL batch or stored procedure. You can specify an optional integer variable with RETURN to pass a status value to the calling

If a RichTextBox control has the focus in a Multiple Document Interface (MDI) child form, it doesn’t properly regain the focus after your application loses and regains focus. To fix

In general, every user tends to work on a separate database on the server during the development phase of an application. It can be annoying for users to repeatedly change

It is possible to see if a check box has been checked or not in JavaScript. This may come in handy during form validation. A check box has a checked

Question: How do I insert page breaks into a SELECT report? The report is sorted by a column that contains about five separate values, and I would like a new

Question: How can I import data into a datawindow if the data blob contains CR/LF as part of its data? I am using dw.object.data and dw.importstring for distributed data transfer.

Question: I have a users table with primary key USERID. The table is already created and loaded with pre-existing data. I now want the USERID field to be self-incrementing&#151that is,

Question: How do I change the code page in SQL Server 7.0 once it has been installed? Answer: The code page is selected with sort order upon install. Though you

Question: I am trying to create a procedure that first drops the table “table” but only if it already exists. How do I create the statement using “if exists” or