> 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) ;


even worst :( !! the error doubles !!!

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

Statement #3:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 2, char 1
END

By the way: I'm using Mitec IB Query Program, in SQL
Editor mode... which program are you using ??

Giuliano



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