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?