Accuracer: The First And Only Cross-Platform BDE Replacement
Client-Server Single-File Embedded Database with SQL for Delphi / C++Builder / Kylix


TACRBatchMove.Mode
TACRBatchMove
Top 

Specifies what the TBatchMove object does when the Execute method is called.

Delphi syntax:

property Mode: TACRBatchMode;

C++ syntax:

__property TACRBatchMode Mode = {read=FMode, write=FMode, default=0};

Description

Use Mode to indicate whether the TACRBatchMove object should add records, replace records, delete records, or copy the Source. These are the possible values for Mode:

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.

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.

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.





© AidAim Software Accuracer: Client-server Database Single-file Database Delphi Database Embedded Databas