Raise an exception in your trigger - this will get you an exception in your
calling application. Then, you can abort your transaction.


Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com


Is it possible to abort the transaction and return to calling program
(i.e. Builder,Delphi,etc...) from a Before Delete Trigger. I have to
perform checks before deleting a record and want to enforce it using
a trigger. I know that I should be utilizing RI for this but I am
constrained because this is a conversion and I need a stopgap measure
until I have all the RI in place.


[Non-text portions of this message have been removed]