Name 

Description 

Creating a Batch Move Component 

 

Executing a Batch Move 

Use the Execute method to execute a previously prepared batch operation at runtime. For example, if BatchMoveAdd is the name of a batch move component, the following statement executes it:  

The Data Dictionary 

When you use the BDE to access your data, your application has access to the Data Dictionary. The Data Dictionary provides a customizable storage area, independent of your applications, where you can create extended field attribute sets that describe the content and appearance of data.
For example, if you frequently develop financial applications, you may create a number of specialized field attribute sets describing different display formats for currency. When you create datasets for your application at design time, rather than using the Object Inspector to set the currency fields in each dataset by hand, you can associate those fields... more 

Tools for Working with the BDE 

One advantage of using the BDE as a data access mechanism is the wealth of supporting utilities that ship with Delphi. These utilities include:

• SQL Explorer and Database Explorer: Delphi ships with one of these two applications, depending on which version you have purchased. Both Explorers enable you to
• Examine existing database tables and structures. The SQL Explorer lets you examine and query remote SQL databases.
• Populate tables with data
• Create extended field attribute sets in the Data Dictionary or associate them with fields in your application.
• Create and manage BDE aliases.

SQL Explorer lets you do the following... more 

Specifying a Batch Move Mode 

The Mode property specifies the operation a batch move component performs:
Batch move modes  

Using TBatchMove 

TBatchMove encapsulates Borland Database Engine (BDE) features that let you to duplicate a dataset, append records from one dataset to another, update records in one dataset with records from another dataset, and delete records from one dataset that match records in another dataset. TBatchMove is most often used to:

• Download data from a server to a local data source for analysis or other operations.
• Move a desktop database into tables on a remote server as part of an upsizing operation.

A batch move component can create tables on the destination that correspond to the source tables, automatically mapping the column... more 

Handling Batch Move Errors 

There are two types of errors that can occur in a batch move operation: data type conversion errors and integrity violations. TBatchMove has a number of properties that report on and control error handling.
The AbortOnProblem property specifies whether to abort the operation when a data type conversion error occurs. If AbortOnProblem is True, the batch move operation is canceled when an error occurs. If False, the operation continues. You can examine the table you specify in the ProblemTableName to determine which records caused problems.
The AbortOnKeyViol property indicates whether to abort the operation when a Paradox key... more 

Mapping Data Types 

In batAppend mode, a batch move component creates the destination table based on the column data types of the source table. Columns and types are matched based on their position in the source and destination tables. That is, the first column in the source is matched with the first column in the destination, and so on.
To override the default column mappings, use the Mappings property. Mappings is a list of column mappings (one per line). This listing can take one of two forms. To map a column in the source table to a column of the same name in... more