TMyDumpOptions.InsertType Property

Used to specify the method of rows insertion into a table.

Class

TMyDumpOptions

Syntax

property InsertType: TMyInsertType default itInsert;

Remarks

If the InsertType property is set to itInsert (by default), new rows are inserted into an existing table, an error is raised in case if there is a duplicate entry.

If the InsertType property is set to itInsertIgnore , the insert operation fails silently for rows containing the unmatched value, but inserts rows that are matched without generating an error.

If the InsertType property is set to itReplaceInto if an old row in the table has the same value as a new row, the old row is deleted before the new row is inserted.