Vito Chiarello wrote:

>
> Resource Exception. unsuccessful metadata update
> object <table name> is in use
> Reason: unsuccessful metadata update
> object <table name> is in use
>

In Firebird 1.x you can add foreign keys only if

1) you are the only user connected to the database
2) you have only one connection
and
3) you have not used either of the tables in the
foreign key relations in the current connection.

Firebird 2 is much easier, but not quite released yet.


Regards


Ann