Question: I have a field in one of my SQL Server Database tables which I want to increment every time a user enters a new record. I thought about a

Question: I have a table with a datefield as part of the key. This was needed because it stores historical information. I need to know how to write an SQL

Question: Is there a way to have SQL Server assign values to key fields automatically, so that every time a new record is added it just increases the prior record’s

Question: Please describe the basic components of a table in the relational model. Answer: A table has an intension and an extension. You can think of the intension of a

Question: I have a small SQL Server 6.5 database running on NT Workstation. From my workstation I can ping that machine and I can map a drive to that machine.

Question: I want to use Union to union two different tables, but they are in different databases. An error message told me that I can’t use Union in this way.

Question: I have a simple query using an SQL statement for returning matching records from an IIS Web server using ASP. I need a new query which returns a match

If you are developing COM components that run under MTS (Microsoft Transaction Server), you will notice that many times your transaction automatically gets aborted. You can easily avoid this situation

The Visual InterDev Scripting Object Model (SOM) offers many time saving techniques for coding Web pages and remote scripting. However, you can lose a lot of time when the finicky

The import directive in Java can sometimes be confusing. For example, if you put this line at the top of your source file: import java.util.*; Do all the classes in

Question: I just want to know where Java came from. Can you give me a history of this language? Answer: I can give you a brief history. Java started out

Question: I just wanted to know if you could share some techniques on how to optimize SQL queries (for example, inner join first before performing some steps, do not use

Question: How can I detect that a window has been resized?I can detect events such as WindowIconified,WindowDeiconified, WindowOpening, WindowClosing, etc., but not the resize event. Answer: Figuring out how to

Question: Every time I try to compile a program, I get “Error(0) Duplicate Resources” and the program stops. I understand that this is a linker error of some kind, but

Question: I am learning Delphi 4. I’m trying to create a program that can distinguish between a right and left mouse click and perform an operation based on which button

Question: I use an InterBase database with an alias made in BDE. I want to display the record number for a table when I navigate through the records. Your solution

Question: Can you tell me how to get the root drives on a system? Answer: The 1.0 and 1.1 version of the Java APIs did not include a means ofdetermining

Question: I am trying to create a queue that will be emptied by multiple threads simultaneously. In C/C++ this requires the use of a conditional semaphore to signal that the

Question: Is there a way to determine the percentage of CPU usage or RAM usagewithin a Java application? Answer: Java does not provide an API for determining CPU usage, but

Question: How can I create cells in a JTable that span multiple rows/columns,as you can do in HTML with the rowspan/colspan tags? Answer: To the best of my knowledge, it

Question: How do I access an MS SQL 7 Stored Procedure that returns a multi-row Dataset through Delphi 3? InterBase allows selecting from a Stored Procedure. MS SQL 7 only

JDK 1.2 includes a new library of data structures called Collections. The Collections API contains object collection data structures. The Collection interface is the root interface for all the Collection

The Visual InterDev 6 Grid design-time control (DTC) is a great timesaver. However, sometimes you need to change elements on the fly according to user actions. For instance, your normal

Here is a simple function you can use to connect to SQL Server. This function attempts to connect to the server either using the default SQL Server authentication or Windows

Besides using a BEGIN DISTRIBUTED TRANSACTION statement, another way to instruct SQL Server to participate in a distributed transaction and inform the Microsoft Distributed Transaction Coordinator (MS DTC) of that

The Swing Timer is a useful utility offered by the java.swing package in JDK 1.2. This code snippet shows how to use the timer in an application: 1. ActionListener listener

An HTML form usually looks like this: where you have to specify the action within the Form tag, thus limiting a “post” method to only one destination. However, the JavaScript

Question: How can I undelete a record from a Paradox table? Answer: You can’t. Period. When you delete a record from a Paradox table, its space still exists, but its

Question: In your answer to my previously posted topic, “Changing label captions in FOR loop,” you suggested I use “Sleep.” When I used it, the loop slowed down but didn’t