FireDAC.Comp.BatchMove.SQL.TFDBatchMoveSQLWriter.WriteSQL
Delphi
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.