Bde.DBTables.TBatchMode

From RAD Studio API Documentation
Jump to: navigation, search

Delphi

TBatchMode = (batAppend, batUpdate, batAppendUpdate, batDelete, batCopy);

C++

enum DECLSPEC_DENUM TBatchMode : unsigned char { batAppend, batUpdate, batAppendUpdate, batDelete, batCopy };

Properties

Type Visibility Source Unit Parent
enum public
Bde.DBTables.pas
Bde.DBTables.hpp
Bde.DBTables Bde.DBTables

Description

TBatchMode indicates the type of batch operation to be performed on a database table.

TBatchMode can take the following values:



Value Meaning

batAppend

Append all records from the source table to the end of destination table. The destination and source tables must not have records with duplicate keys.

batAppendUpdate

If a matching record exists in the destination table, replace it with the corresponding record from the source table. Otherwise, append records to the destination table. The destination table must have an index defined for matching records.

batCopy

Copy the structure and records from the source table into the destination table. If the destination table already exists, delete it and replace it with the new copy of the source.

batDelete

Delete all records in the destination table that also appear in the source table.

batUpdate

If a matching record exists in the destination table, replace it with the corresponding record from the source table. The destination table must have an index defined for matching records.