General information
Category:
Forms & Form designer
Dallas,
If TableUpdate is failed the ON ERROR isn't executed. If you receive error 1705, check if your SET EXCLUSIVE is set to 'OFF'. If it is not TABLEUPDATE problem then you can use RETRY in your ON ERROR code.
Yelena
>OK, that's fine. If I do the check on TableUpdate, after the 1585 error gets trapped, I'm now out of the form and into the On Error prg, with no way back to the form. The situation is the same. Control returns to the next line after the error, (which points to READ Events), and the next line is RETURN to the desk top, application quits.
>
>The ON ERROR is supposed to be a catch all (one per app) where you can gracefully trap an error, display a message, "Update Conflict, Nothing Saved", and continue processing. What have I missed.
>
>Recall in the example, the error is generated by VFP as a share violation not tableupdate() or tablerevert() problem. I also set the buffering to 5 on both tables and that generated an error 1705 (open exclusive) immediately when the second user opened the form.
>
>Thanks for looking.
>
>Dallas
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only