Used to specify the method of rows insertion into a table.
property InsertType: TMyInsertType default itInsert;
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.