In the application I am currently working on I insert rows into a sybase table using dbsqlexec. The table has an insert trigger. Sometimes the insert trigger fails but dbsqlexec does not return an error even though the insert trigger failed. Is there any way to catch the trigger error? I have tried calling dbresults after the dbsqlexec but that too returns a SUCCESS status.
Any help would be appreciated.