TurboDB VCL Component Library TTdbBatchMove.Mode |
Previous Top Next |
Specifies what the TTdbBatchMove object does when the Execute method is called.
Delphi syntax:
property Mode: TTdbBatchMode;
C++ syntax:
__property Tdbtypes::TTdbBatchMode Mode = {read=FMode, write=FMode, nodefault};
Description
Use Mode to indicate whether the TTdbBatchMove object should add records, replace records, delete records, or copy the Source. These are the possible values for Mode:
Value | Meaning |
tbmAppend | 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. |
tbmUpdate | 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. |
tbmAppendUpdate | 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. |
tbmCopy | 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. |
tbmDelete | 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. |
Note: TTdbBatchMode is defined in Unit TdbTypes.