FireDAC.Stan.Option.TFDLockMode
Delphi
TFDLockMode = (lmNone, lmPessimistic, lmOptimistic);
C++
enum DECLSPEC_DENUM TFDLockMode : unsigned int { lmNone, lmPessimistic, lmOptimistic };
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| enum | public | FireDAC.Stan.Option.pas FireDAC.Stan.Option.hpp |
FireDAC.Stan.Option | FireDAC.Stan.Option |
Description
Specifies the database record locking mode.
You can use locks to resolve a conflict of updates to the same record from different DBMS sessions.
| Name | Description |
|---|---|
| lmNone |
No locking at all. |
| lmPessimistic |
Pessimistic locking, if DBMS supports SELECT FOR UPDATE, otherwise optimistic locking is used. If the record is locked, then FireDAC waits a certain amount of time (LockWait), if DBMS supports lock timeout, otherwise - it depends on the DBMS settings. |
| lmOptimistic |
Optimistic locking. |