Databases and BDE

The simplest database program - edit, add to, delete from and navigate in a database table without writing a single line of code. (8/99)

Interactively filtering a table - a useful utility for displaying any table and filtering on any filterable field, this shows how to select databases, tables, and fields at run time from a combo box, how to apply a filter, and how to use a timer to prevent the filtering process from slowing user input to the filter edit box. Downloadable source, form, and .exe (1/2000)

Generating a unique ID for a table row - substituting your own logic for the problematic "auto-increment" fields provided by the DBMS. (1/2000)

Copy one table to another- especially useful with the ADOExpress components (since they can't use TBatchMove) (10/2001).

Creating a database at run time - TSession, creating aliases at run-time, creating tables at run-time.

Packing tables to remove deleted rows - A third party class, and some notes on creating your own packer (completely updated 11/99).

BDE Performance - The Borland Database Engine provides important advantages by abstracting the interface to a variety of DBMS. Here are some performance measurements and some performance parameters.

Performing A Query In A Thread That Links To A Form Grid - Refreshing SQL queries in a thread is a great way to improve apparent performance - but how can it be integrated with data aware controls on the grid? (3/11/98)

Overriding The OpenCursor() Method - If you need to detect when a table is opened or closed, and perhaps take special action to prepare for opening or closing, this describes what you need to do. (12/16/98)

Dynamically Creating Lookup And Calculated Fields - If you need to create lookup and calculated fields at run-time, have a look to see how easy it is. (10/99)

Scanning An Application's Query And Table Objects For Refresh - Shows how to examine all of the table and query objects in your application and detect what tables they are using so that you can refresh when you have changed data through a different table or query that uses the same underlying table. (12/99)