ASE 12 on Unix with a C-App
The code I have inherited is inserting rows into a database using ct_send from a c-application and sending just a simple "insert ..." command - although it is a big simple insert command.
I know some of the inserts will be rejected as the information will already be in the table but am unsure about how to detect that the insert failed because it was a duplicate and not for some other reason - any ideas ?
I know I could write a stored proc and get it to return a status and just call the proc with parameters from the c-app, but I would like to make as little change as possible.
TIA
Andy
The code I have inherited is inserting rows into a database using ct_send from a c-application and sending just a simple "insert ..." command - although it is a big simple insert command.
I know some of the inserts will be rejected as the information will already be in the table but am unsure about how to detect that the insert failed because it was a duplicate and not for some other reason - any ideas ?
I know I could write a stored proc and get it to return a status and just call the proc with parameters from the c-app, but I would like to make as little change as possible.
TIA
Andy