Tip Bank

Question: What is the function of the DECLARE keyword in an SQL program? I am aware you can DECLARE cursors in embedded SQL. Are there any other instances where DECLARE

Question: I’m using SQL queries in Delphi 4 to access a database. Some of the field names in the database are either reserved keywords or invalid in some way (for

Question: Is it possible to return a number in a column, using a function, for each row in my result set? For example: “Select RowNum As Rw, Fname, Birth From

Question: If I don’t know the table names beforehand, how do I get the table names out of the database? Answer: Use this: SELECT NAME FROM SYSOBJECTS WHERE TYPE =

The navigation bar controls that come with Visual InterDev 6 cause more than their share of problems for newcomers. The most frequent complaint is that the navigation bar doesn’t show

While debugging and running COM components under MTS (Microsoft Transaction Server), you may get automation errors, or time outs, or your transaction may abort. This may happen if you have

A previous tip, “Get a Hold of Swing Defaults,” shows how to obtain the default settings for Swing components. It is easy to change any default settings programmatically. For example,

Question: I want to assign the result of a SQL statement to a multi-line text box, and I want to format the individual fields using the Format function. Can I

Question: Can I retrieve data from a text file instead of querying an Access database? Answer: Yes, you can access a text file from an ASP page. Use the FileSystemObject