>>Hi Marc,
>>
>>Well you didn't mention TRANSACTION control before either.
>>
>Jim, no I'm not locking during the transaction, but during data entry, _before_ the save. I update the database only when the document is validated, and that I do under a transaction.
>
>>However, maybe PESSIMISTIC table buffering (4)would do the trick for you here - the records would be locked automatically from initial access until successful END TRANSACTION or ROLLBACK.
>>
>
>Under the transaction the tables are locked, which ever buffering you use.
>
>>Good luck Marc,
>>
>
>Thanks Jim :).
>
>And thanks for you suggestions.
>
>Marc
Marc,
Pessimistic might be the way to go but it will be very restrictive for the other users of the system. You might want to investigate TABLEUPDATE() further. If you pass a .T. as second parameter it will force your change, that is, even if someone else has updated the record after you got an 'image' of it.
José