One of the oldest and most common concerns in multi-user database applications is how to insure data consistency, particularly how one user can avoid overwriting data that was edited by another user. To address this concern, applications provide a capability or technique called record or row locking. Record locking usually falls into one of two categories, pessimistic or optimistic. Both categories have their benefits and drawbacks. This tech note describes a user-friendly approach to working with record locking.

Download Complete Tech Note: Tech Note Document