Configuring the Web Interface › Record Locking Behavior in the Web Interface

Record Locking Behavior in the Web Interface

When a user edits a database record using the web interface, the user is given an exclusive lock at the record for the default time of two minutes. You can change the default time by using the ExclLockSeconds property in the web.cfg file.

The following conditions affect if a database record is updated by a user's changes:

• If a user can edit and submit changes within an allotted time, the changes are included the database.

  During the time that the database record is locked, other users (both web and non-web) can view the record, but cannot edit it. If another user tries to edit the record while it is locked, an error message appears.

• If a user cannot edit and submit changes within an allotted time, the record lock automatically drops and other users can edit the record.

  When the user submits the updates, time stamps are checked to ensure that nobody else has changed the record and the following occurs:

  • If the record has not been changed since the exclusive lock was dropped, the user’s updates are saved to the database.
  • If another user has edited the record after the lock expired, the user receives an error response from the attempt to save, and the changes are not saved. The user must restart the edit process and re-enter the changes.

More information:

Configuration File Modification