TADUpdateSQL.UnlockSQL Property

Specifies the SQL statement to use when unlocking a record.

Group

Links

TADUpdateSQL Class, TADUpdateSQL Members, uADCompClient Namespace, published, See Also

Set UnlockSQL to the SQL statement to use when unlocking single record in a database. Library uses the statement if UpdateOptions.LockMode is pessimistic or optimistic.

To submit to a command a dataset original field value, use the :OLD_<field name> parameter name. Statement can use additional parameters and macros. To get access to the parameters or macros collection use Commands property.

Most DBMS's unlock record after finishing transaction. So, AnyDAC does not generate any SQL statement for record unlocking by default.

See the Commands property for details of how to use macros or additional parameters in the command text.

Syntax

property UnlockSQL: TStrings;