Page History
...
If you need to read rows before finding the one to modify, don't lock until you find the row you want, but read again after you lock it.
See also
Remarks
Lock alerts the network system that the program wishes to establish a lock on a table or row. If the program attempts to set a lock that has been previously set by another user, the current program will execute the Else statements.
...
