Subject Re: [firebird-support] Triggers: Stop original command
Author Helen Borrie
At 07:55 PM 28/03/2006, you wrote:
>Hi,
>
>Is there a way to stop the execution of the original command that
>fired a trigger from within the trigger-procedure in FB? (like RETURN
>NULL in PostgreSQL)

create exception EXECUTION_ABORTED 'Execution was aborted';
commit;
set term ^;
create trigger blahblah for blah
active before insert or update or delete
as

begin
do_some_stuff;
if (something_bad_happens) then
exception execution_aborted;
end ^

./hb