INF: Use of Timestamps in Browse Mode

ID Number: Q45254

1.00 1.10 1.11 4.20

OS/2

Summary:

Timestamps are an alternative to using locks to prevent one process

from wiping out the updates of another process. Timestamps are used in

browse mode because locking would cause too many delays through

contention. The timestamp column is automatically updated by SQL

Server. The WHERE clause constructed by dbqual contains the comparison

necessary to prevent updates to rows that have been changed since they

were last read. Just decide how to let the user know that the value

has changed since it was last displayed.