FireDAC.Comp.BatchMove.SQL.TFDBatchMoveSQLWriter.WriteSQL
| [–] Properties | |
|---|---|
| Type: property | |
| Visibility: published | |
| Source: FireDAC.Comp.BatchMove.SQL.pas FireDAC.Comp.BatchMove.SQL.hpp
| |
| Unit: FireDAC.Comp.BatchMove.SQL | |
| Parent: TFDBatchMoveSQLWriter | |
Delphi
property WriteSQL: String read FWriteSQL write FWriteSQL;
C++
__property System::UnicodeString WriteSQL = {read=FWriteSQL, write=FWriteSQL};
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.