The UpdateOptions property has the following sub-properties:
- LockMode, LockWait, and LockPoint: If you are building an application (or part of it) where concurrency happens, you may want to specify the lock strategy and some parameters to fine-tune it. For example, if the underlying database supports the SELECT FOR UPDATE (or the like) statement (for example, in Oracle, Firebird, MySQL, and many more), you can set LockMode to the lmPessimistic value in order to obtain FireDAC to lock a record before editing it. Furthermore, you can specify (through the LockPoint property's value) whether the lock should be acquired at the moment the dataset starts editing the record (that is, when the State property of the dataset goes from dsBrowse to dsEdit) or when the changes are posted (that is, when the TDataSet.Post method gets called). But there's more: if the lock strategy is pessimistic and the record is already locked...