stop trigger

[Aurel Pekarčík]

Hello, I need test a condition in before_trigger and then in some cases stop execution and return a application error code, like :

create trigger Docs_BD before delete on Docs for each row
begin
DECLARE aCnt integer;
SET aCnt = SELECT count(*) FROM Items where ID = Old.ID;
IF IfNull(aCnt,0) <> 0 THEN
SET @ErrMsg = 528; -- Application error -- Error528: Cant delete document with items;
BREAK ?
ERROR ?
-- HOW STOP THE TRIGGER ? ---
END IF;
end;

Any suggestion ?

Thanks.