Online Documentation for Advanced Data Import for RAD Studio VCL
TQImport3.ImportMode
type TQImportMode = (qimInsertAll, qimInsertNew, qimUpdate, qimUpdateOrInsert, qimDelete, qimDeleteOrInsert);
property ImportMode: TQImportMode;
Description
The ImportMode property allows you to define actions executed while importing data. The following values are available:
|
qimInsertAll |
Inserts all the records from the source file to the target object |
|
qimInsertNew |
Inserts records which are not in the target object yet, others are skipped |
|
qimUpdate |
Updates those records which already exist in the target object, others are skipped |
|
qimUpdateOrInsert |
Updates existing records and inserts new records |
|
qimDelete |
Deletes those records which already exist in the target object, others are skipped |
|
qimDeleteOrInsert |
Deletes existing records and inserts new records |
Note that for all of these modes, except InsertAll, you should define the KeyColumns property for defining the columns to search by.
See also:
