Hello All!

I am a complete newbie to firebird and i am trying to migrate a DDL script
from another RDBMS system.

I made the following testcase in a script-file.

create table A (
ID DOUBLE PRECISION NOT NULL PRIMARY KEY
);

create table B (
ID DOUBLE PRECISION NOT NULL,

FOREIGN KEY (ID) references A(ID)
);

commit;

exit;

When running the creation of table A works perfect, but it seems to me while
adding the foreign key, the following error arise:

>isql "c:\firebird\seetec.fbd" -i 'c:\firebird\testcase.sql' -u sysdba -p

masterkey

Statement failed, SQLCODE = -607

unsuccessful metadata update
-object A is in use
Expected end of statement, encountered EOF



Any hints, workarounds, tips??? Any help would be appreciated.
Sorry if it's a too common question, but I can't figure it out.

Thanx a lot.

Chris