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

No, it shouldn't. You set the command terminator to !!

> But even with this, ... no hope :
>
> Statement #2:
> Dynamic SQL Error
> SQL error code = -104
> Unexpected end of command

Show the complete command you're trying to run.

Are you running this as a script, or as a single command?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com