FireDAC.Comp.BatchMove.SQL.TFDBatchMoveSQLWriter.WriteSQL

From Appmethod Libraries
Jump to: navigation, search

Object Pascal

property WriteSQL: String read FWriteSQL write FWriteSQL;

C++

__property System::UnicodeString WriteSQL = {read=FWriteSQL, write=FWriteSQL};

Properties

Type Visibility Source Unit Parent
property published
FireDAC.Comp.BatchMove.SQL.pas
FireDAC.Comp.BatchMove.SQL.hpp
FireDAC.Comp.BatchMove.SQL TFDBatchMoveSQLWriter

Description

Use the WriteSQL property to specify a writing SQL query.

Use the WriteSQL property to specify a SQL query, which will be used to write the data to the destination database. The SQL query should be a parameterised SQL command like INSERT or MERGE. The source data columns will be matched to the SQL query parameters by names. If a parameter does not have corresponding source column, then NULL value will be assigned to the parameter.

When WriteSQL is specified, then BatchMove.Mode is almost ignored. Otherwise TFDBatchMoveSQLWriter automatically generates a writing SQL command based on the BatchMove.Mode property value. The TFDBatchMoveSQLWriter executes the SQL command using FireDAC Array DML with the array size equal to BatchMove.CommitCount.

See Also