How to lock a record while it is opened by a user ?

Aure69

Hi,

We work on a 2.60 Finanancials version w/ a SQL db. We would like to lock the records for all the headers of every purchase/sales documents. ie when a user is working on an quote/order/invoice... no one can et access to it while the record is opened. Do you see any way to do this ?

Thanx in advance for yr help.

ara3n

I wouldn't use locking to give this feature to the client.

Issueing a lock, doesn't lock sql record, but rather sql makes the transaction serializable. So SQL will make the decision when to lock the record, or a page or the whole table.



Anyways I would rather create a new field called "Is being Modiied by", fill it in by the userID and do not allow anybody to modify the record, once the order is release, remove the field.