FireDAC.Comp.Client.TFDUpdateSQL.UnlockSQL
Delphi
property UnlockSQL: TStrings index 4 read GetSQL write SetSQL;
C++
__property System::Classes::TStrings* UnlockSQL = {read=GetSQL, write=SetSQL, index=4};
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| property | published | FireDAC.Comp.Client.pas FireDAC.Comp.Client.hpp |
FireDAC.Comp.Client | TFDUpdateSQL |
Description
Specifies the SQL statement to use when unlocking a record.
Set UnlockSQL to the SQL statement to use when unlocking a single record in a database. The library uses the statement if UpdateOptions.LockMode is pessimistic or optimistic.
To submit a dataset original field value to a command, use the :OLD_<field name> parameter name. The statement can use additional parameters and macros. To get access to the parameters or macros collection, use the Commands property.
Most DBMSs unlock records after finishing a transaction. So FireDAC does not generate any SQL statement for record unlocking by default.
See the Commands property for details on how to use macros or additional parameters in the command text.