Here is a simple way to improve performance with respect to recordset traversal of your MDAC (Microsoft Data Access Components) application. If you want to traverse the recordset then you

Question: I’ve inherited an Access database with embedded spaces in the column names. I use SQL with Visual Basic and want to select these columns and alias them so that

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 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’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: I have a field called StartDateTime. In Microsoft Access it contained only a time. My code used to sort this field properly when outputting, so that morning events appeared

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 =

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)

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

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

Any time the behavior of your code depends on the Timer function you should take into account the (more or less) remote possibility that your code is executed just before

The following routine quickly check that a string contains a valid GUID. Of course, it doesn’t check that the GUID refers to a valid entity, but at least it lets

Both VB5 and VB6 include a hidden function, named VarPtr, that returns the address of a variable. Many advanced tricks and routines, on VB2TheMax or other site, use this function.

You can use an external JS file to store modular JavaScript code. In addition to being modular, it hides your JavaScript code from novice users. However, it is possible for

Swing is one of the best things that happened to Java GUI developers. At the heart of Swing is the javax.swing.UIManager class (com.sun.java.swing.UIManager for Swing 1.03 and below) that keeps

Stored procedures offer many advantages over dynamic SQL, including improved performance and scalability. The SQL code in a stored procedure is parsed and normalized when you create it. Stored procedures

Dynamic allocation of an exception (as in this example) is not a good idea: class Err{public: Err(const char * description);};void f(){ if (disaster) throw new Err(“failed”); //exception object is dynamically

You can apply STL generic algorithms to a sequence of elements. They are defined in the header file . (on pre-standardized implementations, the name is used instead). Iterators are used

Even macros that look harmless can have detrimental effects. For example: #define twice(x) ((x)+(x)) The macro, twice, is well parenthesized and performs a simple addition operation. Despite its simplicity, there

STL is divided into two major categories: containers and algorithms. Additional components are iterators, function objects, numeric facilities, allocators, and miscellaneous utilities. STL containers are defined in eight different header

As opposed to what most people believe, portability does not guarantee that you can compile and run the same code on every platform without any modifications. Although it is sometimes

Use this code for a generic routine to load a grid from a SQL statement. The example is for Remote Data Objects (RDO) and Sheridan Software Systems’ grid, but it

With VB4 or higher, you can place invisible controls-such as the standard Timer and CommonDialog or UserControls built with VB5 that have their InvisibleAtRuntime property set-directly on an MDIForm. In