From Appmethod Libraries
Jump to: navigation, search

Object Pascal

property WriteSQL: String read FWriteSQL write FWriteSQL;


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


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


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