Bde.DBTables.TBatchMove.Mode

From RAD Studio API Documentation
Jump to: navigation, search

Delphi

property Mode: TBatchMode read FMode write FMode default batAppend;

C++

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

Properties

Type Visibility Source Unit Parent
property published
Bde.DBTables.pas
Bde.DBTables.hpp
Bde.DBTables TBatchMove

Description

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

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



Value Meaning

batAppend

Append the records in the source to the destination table. The destination table must already exist, and the two tables must not have records with duplicate keys. This is the default mode.

batUpdate

Replace records in the destination table with matching records from the source table. The destination table must exist and must have an index defined to match records.

batAppendUpdate

If a matching record exists in the destination table, replace it. Otherwise, append records to the destination table. The destination table must exist and must have an index defined to match records.

batCopy

Create the destination table based on the structure of the source table. If the destination already exists, the operation will delete it, and replace it with the new copy of the source.

batDelete

Delete records in the destination table that match records in the source table. The destination table must already exist and must have an index defined.



See Also