Subject Re: ISQL & trigger
Author giulfin2002
> Show the complete command you're trying to run.
> Are you running this as a script, or as a single command?
Hi Martin !
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 Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL &
by the way ... I would like the java application to work with firebird
and 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 &
generator) ??

Thanks for your help