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


TSQLMemTable.BatchMove
TSQLMemTable
Top 

Moves records from a dataset into this table.

function BatchMove(ASource: TSQLMemDataset; AMode: TSQLMemBatchMode): Int64;

Description

Call BatchMove to

·Copy records from another table into this table.  
·Update records in this table that occur in another table.  
·Append records from another table to the end of this table.  
·Delete records in this table that occur in another table.  

ASource is a dataset component containing the records to import or (if deleting) match. The AMode parameter indicates what operation to perform (copy, update, append, or delete). This table is the destination of the batch operation.

BatchMove returns the number of records operated on..

Note:The process of import may take a long time if you work with large table. You may set the OnProgress event handler to provide the user with a feedback about the progress of the slow process or to cancel the process.  




© AidAim Software SQLMemTable: In-memory Sql Database Delph