You can enable and disable triggers on tables for SQL Server 7.0. This means you don’t need to drop triggers and recreate them if some process (which requires that triggers

Database backups from one MS SQL Server (server1) could be used to create a copy of the database on another MS SQL Server (server2). But existing user to login mappings

The easiest way to make ensure that a user picks a value from a dropdown list is to add a value to the top of the list that isn’t really

C code, which of course is unaware of object semantics, can access the data members of a C++ object directly, but certain requirements must be met. There are some guarantees

You can use ODBC settings to avoid truncation warnings from MS SQL Server. These warnings occur when the application tries to insert or update data that is larger than its

Piped streams are typically used in separate threads. One thread writes output to a PipedOutputStream. The other thread reads the same data from a PipedInputStream. The two streams are connected

In a typical application using piped streams, an object of type PipedInputStream and an object of type PipedOutputStream are started as separate threads. One thread uses a PipedOutputStream to output

If you set objects to Nothing, then test their nothingness, this suggestion might help you. If you declare an object as New and later set it to Nothing, VB won’t

The Standard Template Library (STL) provides only one type of associative container–the sorted associative container. The STL sorted associative containers are map, multimap, set, and multiset. However, there is another

If you are preparing Active Server Pages code for printing or for code review it helps to make the script as tidy as possible. A free utility called HTML Tidy

If you develop large apps, this routine can help you keep a count of calls to change the mousepointer. The routine, called MouseStack, keeps a stack of those calls and

You can make your TreeView or ListView control behave like a menu so that as you move the mouse cursor over the items, the highlighted item moves with the cursor.

Low-level parsing in VB doesn’t come up every day. This routine demonstrates how to search a VB module for dead module-level constants with only a few lines of code. Reading

To obtain the ASCII value of a character, simply assign the char variable to an int variable. For example: char aChar=’B’;int charVal = aChar; Then System.out.println(“”+charVal); will print the ASCII

ArgumentParser simplifies command-line argument processing by separating arguments into positional parameters and options (any argument starting with “-” or “/” is considered an option, which may specify a value). Construct

Some C++ programmers develop Win32 API DLLs that can used from Visual Basic programs. Use the __stdcall prefix with functions exported from the C++ DLL that you want to access

Use this simple subroutine to move the mouse/cursor to the center of an object. It’s useful for tab-like functions and default settings: Private Declare Function SetCursorPos& Lib _ “user32” (ByVal

When working with ActiveX DLLs, many VB programmers build a reference DLL first, copy it to a subdirectory of the project directory, and set version compatibility to binary with a

The ASP Session object helps you maintain state in the Web’s stateless environment. That means that you can track users and their choices from one page to another. However, all

You don’t need a lot of documentation to use objects in your Active Server Pages. Because objects are self-documenting, you can usually find the information you need about their methods,

An overloaded operator must take at least one argument of a user-defined type (operators new and delete are an exception). This rule ensures that users cannot alter the meaning of

Question: I have a layer and I want to make the text inside scrollable. I use SPAN (or DIV also works okay) and it looks fine in Internet Explorer. But

The Standard Library’s auto_ptr class template automatically destroys an object that is allocated on the free store when the current scope is exited. For example: #include //definition of auto_ptr#include using

To add a hyperlink listener in Java, add it to the JEditorPane and set its contents. A lot of errors may be thrown, but this is how the hyperlink listener

The Active Server Pages Request object gathers lots of information about the server and the browser. This information is stored in the ServerVariables collection. You can iterate through the entire

In this example, main() is missing an explicit return statement. int main() { printf(“hello world”); } In C, when control reaches the end of main() without encountering a return statement,

You can use Visual Basic to create ODBC Data Sources Names (DSNs) dynamically for MS SQL Server. Simply place this line in a module: Declare Function SQLConfigDataSource Lib “odbccp32.dll” (ByVal

With Dynamic HTML and Internet Explorer 4 and 5 you can update the text on the page after the page is rendered. The trick is to use the ID attribute