Ever had a user accidentally create a query that resulted in a Cartesian product of your two largest tables? Of course, a badly written query uses up precious CPU and
Most nontrivial applications are packaged with “resource files,” which are nothing more than files used by the application for various purposes. Some examples of these resources include image (GIF, JPEG)
While the Visual InterDev 6 Scripting Object Model (SOM) is great for rapid development of Web sites, the SOM doesn’t support all HTML attributes. For instance, the SOM doesn’t support
VB6 offers a couple new string functions that work with string arrays. One of these new string functions, Join, concatenates all the items of an array into an individual string
It is now easy to create scripts using the functionality in T-SQL to automate the loading of data into SQL Server with the addition of the bulk insert command in
The Visual InterDev 6 Scripting Object Model provides the navigateURL method for navigating to another Web page based on an event such as a button click. Many people are stumped
When creating programs that use Remote Method Invocation (RMI), you’ll need to obtain a reference to a remote object. Although the name of the specific object will usually be pre-defined
Hexadecimal and octal literals are indicated by special prefixes. A hexadecimal literal is indicated by the ‘0x’ prefix: int n =0x1000; // decimal value of n is 4096 An octal
Suppose you have a table that contains transactions for different products and clients. Each day you need to summarize this information. If you need to know the sales figures for