I want it to happen inside the trigger I need to be able to
encapsulate all behaviour on the server and just return a sucess/no
success code. I want to rollback/end the transaction on the server,
inside the trigger. The calling app us just waiting for a result of
failure or success as a message.

--- In ib-support@y..., Paul Reeves <paul@f...> wrote:
> abizafu wrote:
> >
> > 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.
> >
>
> Look at using exceptions. When the client receives an exception it
can
> then decide whether to continue or rollback.
>
> Paul
> --
>
> Paul Reeves
> http://www.ibphoenix.com
> taking InterBase further