|
|
|
|
TABSBatchMoveType type
|
Top
|
Indicates the type of batch operation to be performed on a database tables.
Unit
ABSTypes
type
TABSBatchMoveType = (bmtAppend, bmtAppendUpdate, bmtCopy, bmtDelete, bmtUpdate);
Description
TABSBatchMoveType can take the following values:
Value
|
Meaning
|
bmtAppend
|
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.
|
bmtAppendUpdate
|
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.
|
bmtCopy
|
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.
|
bmtDelete
|
Delete all records in the destination table that also appear in the source table.
|
bmtUpdate
|
If a matching record exists in the destination table, replace it with the corresponding record from the source table.
|
bmtSynchronize
|
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. If a record in the destination table doesn't exist in the source table, record is deleted from the destination table.
|
|
|