SQLMemTable: BDE Alternative Embedded
In-Memory Database with SQL for Delphi / C++Builder


TSQLMemBatchMode type

Top 

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

Unit

SQLMemMain

type
TSQLMemBatchMode = (batAppend, batUpdate, batAppendUpdate, batCopy, batDelete);

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

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 SQLMemTable: In-memory Sql Database Delph