FireDAC.Comp.BatchMove.SQL.TFDBatchMoveSQLWriter

From RAD Studio API Documentation
Jump to: navigation, search

FireDAC.Comp.BatchMove.SQL.TFDBatchMoveSQLDriverFireDAC.Comp.BatchMove.DataSet.TFDBatchMoveDataSetDriverFireDAC.Comp.BatchMove.TFDBatchMoveDriverFireDAC.Stan.Intf.TFDComponentSystem.Classes.TComponentTFDBatchMoveSQLWriter

Delphi

TFDBatchMoveSQLWriter = class(TFDBatchMoveSQLDriver, IFDBatchMoveWriter)

C++

class PASCALIMPLEMENTATION TFDBatchMoveSQLWriter : public TFDBatchMoveSQLDriver

Properties

Type Visibility Source Unit Parent
class public
FireDAC.Comp.BatchMove.SQL.pas
FireDAC.Comp.BatchMove.SQL.hpp
FireDAC.Comp.BatchMove.SQL FireDAC.Comp.BatchMove.SQL

Description

Note: You cannot use the TableName property and the ReadSQL property at the same time.

Choose TFDBatchMoveSQLWriter as the Writer property of the TFDBatchMove.

TFDBatchMoveSQLWriter supports all the possible TFDBatchMove data movement modes.

Note: The mode dmAppendUpdate is only supported when the database supports MERGE, INSERT OR REPLACE or similar DML commands.

In the modes dmAppend, dmUpdate, dmAppendUpdate, and dmDelete the destination table must have primary key.

See Also