FireDAC.Comp.BatchMove.TFDBatchMove.Mode
Delphi
property Mode: TFDBatchMoveMode read FMode write FMode default dmAlwaysInsert;
C++
__property TFDBatchMoveMode Mode = {read=FMode, write=FMode, default=0};
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| property | published | FireDAC.Comp.BatchMove.pas FireDAC.Comp.BatchMove.hpp |
FireDAC.Comp.BatchMove | TFDBatchMove |
Description
Specifies the TFDBatchMove data movement mode.
Use Mode property to control whether the TFDBatchMove component will add, replace or delete records on the data destination. The possible values are:
| Name | Description |
|---|---|
| dmAlwaysInsert | Appends the records from the source to the destination. No content matching is performed. This is the default mode. |
| dmAppend | Appends the records from the source to the destination, when the records have no matching records in the destination table. The matching is performed using primary key fields. |
| dmAppendUpdate | Appends the records from the source to the destination, when the records have no matching records in the destination table. It also updates records in the destination table that matches records in the source table. The matching is performed using primary key fields. |
| dmDelete | Deletes records in the destination that matches records in the source table. The matching is performed using primary key fields. |
| dmUpdate | Updates records in the destination table that matches records in the source table. |