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

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

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 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