FireDAC.Comp.BatchMove.TFDBatchMove.Mode

From RAD Studio API Documentation
Jump to: navigation, search

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.

See Also