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

Question: How can I go about reading in a (comma-delimited) text file and comparing it to an existing table? If there is a match on the key field, the row

Question: Can you convert Visual FoxPro forms and reports to Oracle forms and reports? If you can, how is this done? Answer: I am not aware of anything that performs

Question: Is it possible to completely hide the main Visual FoxPro window when I run an executable? In my main program, I use “_VFP.Visible = .F.”, but the main window

Question: I need to incorporate Microsoft Word 97 spell-check functionality into PowerBuilder. Which MS Word functions are required to do the task? Answer: To interface to the Word spelling checker

Question: How can I use a Menu Object that associates with MDI to scroll a row in a DataWindow on an ActiveSheet? Answer: To achieve this you should map a

A Visual Basic class module provides an Initialize procedure. The code you write in Initialize is executed when the Visual Basic object is created. However, Initialize is always executed before

Without error handling, any ASP (Active Server Pages) error is fatal as it will stop the execution of your page. To bullet proof your ASP, you can add error handlers.

Question: I often have the problem in which the DHTML on my page loads faster than the accompanying HTML. Therefore, users are enticed to click away at elements, which trigger

Question: I have an index page where the user clicks on a name to bring up that person’s biography on the next page. The names are hyperlinks to the next

Question: I can’t reach an image src in a DIV from another DIV in Netscape. Do you have any suggestions? Answer: The problem that you’re running into here is that

Question: How would a person make a patch to upgrade their software in VB6? Answer: The best way to do this, with the least amount of work, is to use