Page 1 of 1

Lock record demo

Posted: Tue 27 Nov 2007 09:33
by Sawlmgsj
Using the Lock demo.

Two instances of program - edit a record in first.
Try to edit same record in second. Get hour glass and wait.
Only released after saving first instance.

How do I return a message to user of second instance.
Where do I place 'try except' clause?

Have tried it in MSQuery1BeforeEdit, but has no effect - just sits there waiting. Do I need to set anything else?

Thanks,
Steve.

Posted: Tue 27 Nov 2007 13:06
by Antaeus
You should change value of the LOCK_TIMEOUT server variable to get an exception when the lock attempt failed.
More information about this variable you will find by this link.