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
Did you know you can start a job from the Query Analyzer? Here’s how you do it: exec msdb.dbo.sp_start_job @job_name = ‘My SQL job’