SQLMemTable: BDE Alternative Embedded
In-Memory Database with SQL for Delphi / C++Builder
Specifies what the TBatchMove object does when the Execute method is called.
Delphi syntax:
property Mode: TSQLMemBatchMode;
C++ syntax:
__property TSQLMemBatchMode Mode = {read=FMode, write=FMode, default=0};
Description
Use Mode to indicate whether the TSQLMemBatchMove 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.
|
|