I don't use SQL Server, but in my case I set ON ERROR to my recovery function right before tableupdating. My recovery function (usually) corrects and then issues RETRY. Of course, I save the current ON ERROR setting and reset it once I'm done :-).
>I would like to trap connection errors myself instead of presenting users with the system dialog box that quotes the error message and provides OK, Revert, and Help buttons. But I can't seem to get rid of it. Here's the setup:
>
>SQL Server table has a unique index on one field. VFP app uses a remote updateable view of this table (created in code, not in a .dbc). dispWarnings for the connection is set to false. If user enters a duplicate value in the grid and changes rows, the system dialog box fires. I would think that I could use tableupdate() and aerror() in the beforeRowColChange event to handle the error myself, but the dialog box beats me to the punch every time.
>
>Is there any way to suppress that dialog box?
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