Subject | Re: [firebird-support] Triggers: Stop original command |
---|---|
Author | Helen Borrie |
Post date | 2006-03-28T10:48:32Z |
At 07:55 PM 28/03/2006, you wrote:
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
>Hi,create exception EXECUTION_ABORTED 'Execution was aborted';
>
>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)
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