hello again

Is there any way to lock a record while a user is updating it. i have a
multi user inventory for a large car company. If two users open the same
record and make changes, then the one will overwrite the other. Is there
any way in which the record can be locked while a user updates it.

I have thought maybe i could have a time field, and when a record is
retrieved for editing, set this to 5 mins in the future, then if Now()
< timefield, record is locked by other user. Obviously, the end user would have only 5 
mins to edit, which is not very eficient.

im just thinking out loud here.

What are your views?

cheers

jmao

---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/

Reply via email to