PostgresDAC

TPSQLUpdateSQL.Properties.SQL

Previous Next

Returns a specified SQL statement used when applying data updates.

Syntax:

property SQL[UpdateKind: TUpdateKind]: TStrings;

Description:

Returns the SQL statement in the ModifySQL, InsertSQL, or DeleteSQL property, depending on the setting of the UpdateKind index. UpdateKind can be any of the following:

ValueMeaning
ukDeleteReturn the query object used to execute DELETE statements (DeleteSQL).
ukInsertReturn the query object used to execute INSERT statements (InsertSQL).
ukModifyReturn the query object used to execute UPDATE statements (ModifySQL).