giulfin2002 wrote:

>
>
>
>>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
>BEFORE INSERT
>AS
>BEGIN
> IF (NEW.my_number IS NULL)
> THEN NEW.my_number = GEN_ID(my_generator, 1);
>END
>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
>Giuliano
>
>
>

You may have a problem, since MySQL doesn't support triggers other than
in prerelease
versions not yet suitable for real work.

Regards
Uno Engborg


[Non-text portions of this message have been removed]