FireDAC.Comp.BatchMove.TFDBatchMove.Options
Delphi
property Options: TFDBatchMoveOptions read FOptions write FOptions default [poIdentityInsert, poCreateDest];
C++
__property TFDBatchMoveOptions Options = {read=FOptions, write=FOptions, default=12};
Properties
Type | Visibility | Source | Unit | Parent |
---|---|---|---|---|
property | published | FireDAC.Comp.BatchMove.pas FireDAC.Comp.BatchMove.hpp |
FireDAC.Comp.BatchMove | TFDBatchMove |
Description
Specifies the data movement options.
The Mode property is set to [poIdentityInsert, poCreateDest] by default.
Select one or more Options:
Name | Description |
---|---|
poClearDest | Deletes the content of the destination table before data movement, performing a transactional operation like SQL DELETE command. |
poClearDestNoUndo | Deletes the content of the destination table before data movement, performing a non-transactional fast operation like SQL TRUNCATE command. |
poIdentityInsert | When this option is selected, then insert/update of the destination identity columns is enabled. |
poCreateDest | Creates the destination table before data movement, if it does not exist. FireDAC will use the data reader provided in the field definitions. |