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: 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
Question: I have made a databaseconnection to a dbase IV database in VisualInterdev (with global.asa). In the Data View window I can see the tables, but when I open a
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