RAD Studio |  |

Using TBatchMove
Collapse All

The Borland Database Engine (BDE) has been deprecated, so it will not be enhanced. For instance, BDE will never have Unicode support. You should not undertake new development with BDE. Consider migrating your existing database applications from BDE to dbExpress.

Topics

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... 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

Copyright(C) 2009 Embarcadero Technologies, Inc. All Rights Reserved.
What do you think about this topic? Send feedback!