Tip Bank

Whenever possible, use C++ arrays. Array indexing has an order of magnitude of O(1). This means that it is very fast. However, if the size of the array is not

Use this code to cache your repeated calls to the database: Dim mLookup As Scripting.DictionaryDim cn As ADODB.ConnectionEnum enumLookup ltCustomers ltVendors ltSalespeopleEnd EnumPrivate Sub Form_Load() Dim rstest As ADODB.Recordset Set

Suppose you have a “view” into a set of records. One column of the data contains a country ID, (such as “US”): DataView myDataView = new DataView(myTable); myDataView.RowFilter = “country

Suppose you start a thread and you want to wait for that thread to finish before you continue processing. One way is to keep checking if the thread has finished

To remove the read-only checkbox from a common dialog control, add the following constant declaration to the module: Global Const OFN_HIDEREADONLY = &H4& Then, while calling the common dialog, write

If a virtual function in a base class has a default argument that is overridden in the derived class, at run time the value in the base class is always

This is a great tip for DBAs. If you ever end up removing a variable-length column (varchar) or text column from one of your tables, a certain amount of wasted

If a class data frame’s size goes above 64K (65536 bytes), the Java compiler rejects the compilation. The compiler’s limitation is due to its ability to handle the larger data

Most Web-based Perl applications use more than five .cgi Perl scripts. Instead of typing all the DBI information in the script, I created a function you can use that gets