Online Documentation for Advanced Data Import for RAD Studio VCL

TQImport3.ImportMode

 

TQImport3                                


 

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:

KeyColumns property

ImportDestination property