General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL passthrough when error is a unique key violation.
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.
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