|Subject||Re: [firebird-support] ISQL & trigger|
> > SET TERM !! ;No, it shouldn't. You set the command terminator to !!
> > 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 :Show the complete command you're trying to run.
> Statement #2:
> Dynamic SQL Error
> SQL error code = -104
> Unexpected end of command
Are you running this as a script, or as a single command?
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL