Subject | Re: [firebird-support] ISQL & trigger |
---|---|
Author | giuliano lotta |
Post date | 2004-10-04T07:32:24Z |
--- giuliano lotta <giulfin2002@...> ha scritto:
---------------------------------
... 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/
---------------------------------
> 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/