How to raise triggers exceptions to my incoking applications

[wolverine]

Hi, i need to know how to raise triggers exceptions to my invoking client application.

To test that I create a trigger that always fails (using a tablename that not exists or directly using RAISE explicitily). The error is added to ads_err.adt but my application don't fail. An example is:

Error 5177: Trigger execution failed. Error 7200: AQE Error: State = HY000; NativeError = 7041; [iAnywhere Solutions][Advantage SQL][ASA] Error 7041: File not found. Verify the specified path and file name is correct. \\server\shared\testDb\inexistentTable.adt Table name: inexistentTable ** Script error information: -- Location of error in the SQL statement is: 3

Any ideas? Thanks!
Regards.

[jhoehne]

I tried it myself and found that OnPostError() is firing.

[joachim_drr]

only when using Delphi;) Sebastian didn't mention his dev language.

[joachim_drr]

Hmmm....if you append or insert a record and the exception is fired within the trigger, your app should raise it.