FireDAC.Comp.BatchMove.TFDBatchMove.Options
Delphi
property Options: TFDBatchMoveOptions read FOptions write FOptions default [poIdentityInsert, poCreateDest, poSkipUnmatchedDestFields, poUseTransactions];
C++
__property TFDBatchMoveOptions Options = {read=FOptions, write=FOptions, default=60};
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 Options property is set to [poIdentityInsert, poCreateDest, poSkipUnmatchedDestFields, poUseTransactions] 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. |
| poSkipUnmatchedDestFields | When this option is selected, then unmatched by name destination fields will be excluded from movement. |
| poUseTransactions | When this option is selected, then batch movement of each CommitCount records will be surrounded by StartTransaction/Commit |