EMS logo

Products Navigation

Advanced Data Import VCL

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

Advanced Data Import for RAD Studio VCL

On-line Documentation

TQImport3Wizard.ImportMode

 

TQImport3Wizard                                


 

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