🚀 go-pugleaf

Thanks Jeff, I think I am using the latest IBConsole, as I had it shipped to
me only last week. I have excluded the SET TERM and it has now worked.
"Jeff Overcash (TeamB)" <jeffovercash@mindspring.com> wrote in message
news:3DFF7658.F465C696@mindspring.com...
> Works for me.  Make certain you have the latest IBConsole (if that is what
you
> are using) from CodeCentral.  The shipping version had problems with the
old
> style SET TERM as it no longer needs SET TERM.
>
> Franca Lord wrote:
> >
> > Can anyone please help!
> > try to run the this:
> >
> >  SET TERM !! ;
> >  CREATE TRIGGER set_emp_no FOR Employee
> >  BEFORE INSERT AS
> >  BEGIN
> >      new.emp_no = gen_id(emp_no_gen, 1);
> >  END !!
> >  SET TERM ; !!
> >
> > "And came up with this error:
> > Dynamic SQL Error
> > Token unknown -line 5, Char 4
> > :on line 2: ........."
>
> --
> Jeff Overcash (TeamB)
>       (Please do not email me directly unless  asked. Thank You)
> Maybe it was infatuation or the thrill of the chase.
> Maybe you were always beyond my reach and my heart was playing safe.
> But was that love in your eye I saw or the reflection of mine?
> Give me time, won't you give me that time!
> Welcome back to the circus.            (Fish)