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

When using proper names, you sometimes need to capitalize the first letter of each word. For example, you need to convert “john smith” into “John Smith.” With VB3, you had

I always put the word DAO in front of all references to DAO objects. Here are some examples: Dim Db As DAO.DataBaseDim rs As DAO.Recordset This way, VBA knows what

Question: I have 20 user licenses. During some activities, users are being logged in two or three times. Thus I can hit a max user limit with only 9 actual

Question: I am interested in learning SQL on my own and need to know if there are any tutorials or disks that I can obtain so that I can practice

Question: Can you make a query that returns records based on ORDER BY something? There may be mutiple instances, but I only want the one that is the very first

Question: How do you Establish Referential Integrity between 2 tables so that when a ticket is deleted from the TICKETS table all associated information in the customer5 table will be