|Subject||Re: ISQL & trigger|
> Show the complete command you're trying to run.Hi Martin !
> Are you running this as a script, or as a single command?
Having to create the table trought a JDBC connection, I would test the
statements trought a SQL Editor, like Mitec IB Query.
So, theese are the statements that I passed trought the editor, and
that I expect to send in he future trought the JDBC connection:
CREATE TABLE my_table (
my_number integer not null primary key
CREATE GENERATOR my_generator;
set term !!;
CREATE TRIGGER my_before_trigger FOR my_table
IF (NEW.my_number IS NULL)
THEN NEW.my_number = GEN_ID(my_generator, 1);
set term ; !!
> Martijn Toniesby the way ... I would like the java application to work with firebird
> Database Workbench - developer tool for InterBase, Firebird, MySQL &
Is it a nightmare or the problems arise only in the creation statement
(e.g: Innodb & forward key) and data type creation ( e.g: counter &
Thanks for your help