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. |