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