I have long sought after an event that fires when lock is attempted. Simply put, having VFP automatically control your pessimistic locks has many problems. If you must have pessimistic locking, set the buffer mode override to Optimistic. Then, in code, create a class that manually handles the Rlock()'s - just like we did in Fox 2.x.

I don't use pessimistic locks as they are irrelevant in Client/Server scenarios.

< JVP >



>I have design a form and have compile and run it as an exe file...
>This form is set to bufferOverride to Pessismistic Row Buffering
>
>This is the problem....at the design stage if two datasessions are trying to access the same rdecod an error msg will be displayed sying the record is in use by another user....then retuns me back to the form...
>
>But if I run is as an executable....the same messsage appears if someone is editing the same record,..after that the program just terminates instead of returining to the form. How do I trap this error message and return to the form instead?
>
>Can anyone help?
>
>Thanks
>
>Jeff