Tip Bank

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 =

Question: I am trying to use data shaping to get a recordset back. I was using two stored procedures that took one parameter each, but now I need to pass

Question: I have a problem with Views. If I make this query: INSERT INTO ACHATSSELECT DISTINCT VINS_ACHAT.PRO, VINS_ACHAT.QtebouteilleFROM VINS_ACHAT then this is a good one. But if I want to

Question: I have two tables, “grade” and “assignment”: TABLE FIELDgrade grade (char i.e. A..F) low_range high rangei.e. ‘A’, 80, 100 ‘B’, 60, 80 etc.assignment s_ref assign_no grade (numeric i.e. 78)

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 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