On 27 Aug 2005 at 5:11, sdbeames wrote:

>Is there anything wrong with this trigger....

I'm afraid you've encountered a bug in FB parser.

>CREATE TRIGGER LEVELS_TG_BD FOR LEVELS
> BEFORE DELETE
>AS
>begin
> if (exists(select 1 from JOBS where LVL = old.LVL)) then

Try this line:

if (exists(select 1 from JOBS where JOBS.LVL = old.LVL)) then

--
SY, Dimitry Sibiryakov.