Unanswered: dbsqlexec and triggers on the table...
I have a table into which I am inserting rows using dblib i.e the insert statement is executed through a call to dbsqlexec. The table has an insert trigger. The insert trigger fails but dbsqlexec does not return an error stating the insert failed because of the trigger. It reutrns a SUCCESS. Is there any way to catch the trigger error? I have tried calling dbresults after dbsqlexec but that too returns a SUCCESS status even though the insert trigger failed.
Any help would be apprecaited?