Subject Re: [firebird-support] ISQL & trigger
Author giuliano lotta
--- giuliano lotta <giulfin2002@...> ha scritto:


---------------------------------

> SET TERM !! ;
> CREATE TRIGGER my_before_trigger FOR my_table
> BEFORE INSERT
> AS
> BEGIN IF (NEW.my_number IS NULL) THEN NEW.my_number
=
> GEN_ID(my_generator, 1)

GEN_ID(my_generator, 1) ;

... and I think the command terminator in this
particular case should be

GEN_ID(my_generator, 1) !!

But even with this, ... no hope :

Statement #2:
Dynamic SQL Error
SQL error code = -104
Unexpected end of command


Giuliano




___________________________________
Scopri Mister Yahoo! - il fantatorneo sul calcio di Yahoo! Sport
http://it.seriea.fantasysports.yahoo.com/