Name 

Description 

BDE-based Architecture 

When using the BDE, your application uses a variation of the general database architecture described in Database Architecture. In addition to the user interface elements, datasource, and datasets common to all Delphi database applications, A BDE-based application can include

• One or more database components to control transactions and to manage database connections.
• One or more session components to isolate data access operations such as database connections, and to manage groups of databases.

The relationships between the components in a BDE-based application are illustrated in the following figure:

The following topics provide additional information about these components:

• Using BDE-enabled Datasets... more 

Executing an Update Statement 

The ExecSQL method for an update component manually applies updates for the current record. Unlike the Apply method, ExecSQL does not bind parameters in the SQL statement before executing it. The ExecSQL method is most often called from within a handler for the OnUpdateRecord event (when using the BDE) or the BeforeUpdateRecord event (when using a client dataset).
Because ExecSQL does not bind parameter values, it is used primarily when the update object's SQL statements do not include parameters. You can use Apply instead, even when there are no parameters, but ExecSQL is more efficient because it does not check... more 

Using Multiple Update Objects 

When more than one base table referenced in the update dataset needs to be updated, you need to use multiple update objects: one for each base table updated. Because the dataset component's UpdateObject only allows one update object to be associated with the dataset, you must associate each update object with a dataset by setting its DataSet property to the name of the dataset. The DataSet property for update... more 

Using the Borland Database Engine 

The Borland Database Engine (BDE) is a data-access mechanism that can be shared by several applications. The BDE defines a powerful library of API calls that can create, restructure, fetch data from, update, and otherwise manipulate local and remote database servers. The BDE provides a uniform interface to access a wide variety of database servers, using drivers to connect to different databases. Depending on your edition of Delphi, you can use the drivers for local databases (Paradox, dBASE, FoxPro, and Access) and an ODBC adapter that lets you supply your own ODBC drivers.
When deploying BDE-based applications, you must include... more 

Connecting to databases with TDatabase 

 

Managing database sessions 

 

Using BDE-enabled datasets 

 

Using TBatchMove 

 

Using the BDE to cache updates 

 

Using transactions with the BDE