Icon RecordLockProtocol Property

property RecordLockProtocol: TEDBRecordLockProtocol

Usage

Use the RecordLockProtocol property to specify whether the session will use a pessimistic or optimistic row locking model when editing records via navigational methods or SQL statements. The pessimistic row locking model dictates that a row should be locked when the row is retrieved for editing, which is during the Edit method of a TEDBTable, TEDBQuery, or TEDBStoredProc component and during the execution of an UPDATE statement. The optimistic row locking model dictates that a row should be locked when the row modifications are posted to the table, which is during the Post method of a TEDBTable, TEDBQuery , or TEDBStoredProc component and during the execution of an UPDATE statement. Using an optimistic row locking model for remote connections to an ElevateDB Server removes the possibility that dangling row locks will be left on the server if a client application is terminated unexpectedly.

The default value is lpPessimistic.
Image