Delphi Database, Delphi Components from ComponentAce

TABSTable.BatchMove
TABSTable

Top

Performs the batch records move operation specified by Mode.

procedure BatchMove(SourceTableOrQuery: TABSDataSet; MoveType: TABSBatchMoveType; DstTableIndexNameToIdentifyEqualRecords: String = '');

Description
Call BatchMove to perform the batch records move operation from source table or query to the current table.

SourceTableOrQuery is a dataset of a table or query to move records from.
MoveType specifies whether the BatchMove procedure should add records, replace records, delete records, or copy the Source.
DstTableIndexNameToIdentifyEqualRecords may specify index in destination table which will be used to associate records in source and destination tables.

Note:
Specified Index is used to associate records in source and destination tables (to decide whether records are equal or not).
If DstTableIndexNameToIdentifyEqualRecords parameter is blank then BatchMove uses index currently set in destination table.
If there is no active index in the destination table, then BatchMove uses primary index from the destination table.
If there is no primary index, then a temporary index is created on a fields existing in both tables.

Note:
If possible index is temporarily created for the source table too, to speed up move operation.

Note:
Use BeforeBatchMove, OnBatchMoveProgress and AfterBatchMove events to display progress of potentially long batch operation.

Nov 21, 2024