Has anyone had this problem. I am testing my error traping one test I set up is a test that will create a unique key violation. I do this through a passthrough.

I run the test I get a return of -1 and the error message says I have violated a unique key constraint, this is good.

The problem is, the passthrough will not let go of the last error.
I use a passthrough to write this error to an error table I have created, but it will not write to the table because the unique key violation is still in effect.

How do I get ODBC to let go of this unique key error and use the passthrough to write this error message to my error table.