Want to see a list of the developers who worked on VB5 and VB6? Try this: From VB’s View menu, select Toolbars, then Customize…. In the resulting dialog, click on

Don’t put rules for validating text values or formats in the KeyPress event-use the Change event instead. If you “paste” into a text box, the KeyPress event isn’t fired and

You probably already know that if you select multiple controls on a form you can use the Property Window to change one of their common property in one single operation.

You can query SQL Server system tables to retrieve the list of all the stored procedure that are available for the end user and applications. The following routine extract their

When you write lengthy procedures, it is a good habit to change the mouse cursor to an hourglass, and restore it to the original shape when the procedure exits. However,

A procedure is said to contain aliased values if it can refer to the same memory addresses in two or more distinct ways. A typical example is the following procedure:

When you have a long HTML file to edit, scrolling up and down to your working areas can be a real pain. Fortunately, you can apply bookmarks to points in

Components that are implemented as executable files (EXE files) cannot execute in the Microsoft Transaction Server (MTS) runtime environment. The components need to be DLLs that are registered in MTS.

A typical operation in DHTML is to iterate through a collection of objects. Let’s say you’re writing an HTML application that indexes content. Your task is to collect all the

SQL Server 6.5 has an APP_NAME() function which returns the program name for the current session. This function is useful for tracking which client applications are running processes in SQL

It’s often pointed out that the Vector class is expensive to use because all of the methods are synchronized. Java 2 has the LinkedList class, which can serve the same

You can use the Toolkit’s getScreenSize().width to recompute the size of a component at run time. For example, if you have a Frame that is supposed to have the screen’s

While comparing a field to NULL, a SQL query should use the IS operator in place of the “=” operator. The reason is that if the ANSI_NULLS option is On

An object’s destructor invokes the destructors of its direct base classes and member objects. The invocation occurs in the reverse order of the construction of the subobjects. Note, however, that

Successful software projects do not end with the product’s rollout. In most projects, new versions that are based on their predecessors are periodically released. Moreover, previous versions have to be

You should use caution when automatically initializing class variables. In this example, C1 calls setVal() in its constructor, and C2, a subclass of C1, overrides the method to set a

An implicitly-declared default constructor has an exception specification. The exception specification contains all the exceptions of every other special member functions (for example, the constructors of base class and embedded

When working with collections, use an error handler to easily determine if a given key exists in the collection. If you try to access an item from a collection where

Question: Is there a painless way of converting a Novell 4.1 server to N.T. 4 without just performing a total rebuild? There are no applications running from the server but

Question: I was wondering if there is a list available somewhere of all the commands with their syntax for OLE? I want to manipulate Word and Excel from inside Powerbuilder

Question: How do I access more than one database (e.g., Oracle and Access) via a Powerbuilder application? I currently have ODBC drivers for both databases, but cannot access the required

Question: How do I schedule to run my Exe automatically?When I schedule it, the exe does not run. Answer: First, for Command Scheduler to work consistently, the Schedule service must

Question: How can I count how long an application is used? Answer: You can use two time variables for this. Use the first variable to record the start time, then

Question: Do you have any examples of calling MS Word Visual Basic to open, modify, print and close a document (i.e., calling macros, inserting tables)? Answer: Here is an example

Question: I have a question about running NT Server 4.0 with Service Pack 4. On start-up, I’m getting an error in my event log: Source: Server Control Manager, EventID 7023,

String comparison doesn’t work for variables. In fact, only variables referencing the same string will work. The String class has an intern method, which lets you compare two variables. This

SQL Server 7.0 allows field and table names to contain spaces or other characters that violate valid identifier rules. These table or field names should be enclosed in “[” “]”

The Visual InterDev environment can save you a lot of typing if you use the Complete Word command while writing script. Just type the first couple of letters of a

The Procedure Attributes dialog includes a Procedure ID combo box, that lets you associate a particular ID to a given member of the class. You usually use this combo to

It is very simple to retrieve the correct currency symbol, using just plain VBA statements: currSymbol = Trim$(Replace(FormatCurrency(0,0), “0”, “”)) If you can also determine if the symbol precedes or