Many developers using ODBC, JDBC, OLE DB, and ADO are unaware that there is a standards-compliant solution for expressing dates, times, and timestamps in SQL statements. When writing queries in
“ODBC-compliant database” and “JDBC-compliant database” are nonsequiturs. ODBC and JDBC clients can connect to databases that store behavior in the form of methods, triggers, constraints, and stored procedures. The ODBC
You can make your Web pages load faster if you reduce the color depth of in-line graphics. This will make your page more useable, impress your audience, and even save
This tip works equally well in both the Windows NT and Windows 95 browsers, and makes managing HTML files a bit easier by adding some file-type specific menu items to
Namespaces do not incur runtime or memory overhead. The technique used to represent namespaces is called name mangling. This same technique is used to create unique names for overloaded functions
When creating menus and command buttons, use the ampersand symbol to create a shortcut key for that option. For example, you might use “&Cancel” for a command button with a
VB doesn’t have a function to replace part of a string (of n-length) with another string (of x-length). The Mid() statement works only with target and replacement strings of the
Use the Win32 API to set tab stops in a Visual Basic list box by creating these declarations and routine in a module: Public Const LB_SETTABSTOPS = &H192Declare Function SendMessage
To change text in a text box to uppercase as soon as the user types it in, use this code: Private Sub txtname_KeyPress(KeyAscii As Integer) ‘Puts in uppercase as soon