Dear Helen,

> Try committing the transaction in which you create Table 1, before
> attempting create a foreign key that references it. It's not

a "new"

> anything until those metadata get committed.
>
> As for "documents/descriptions", it seems you need to understand

the

> concept of transactions. You might like to try a couple of

TechInfo sheets

> on the subject at the TechInfo page of www.ibobjects.com. Another

place

> where transactions are reasonably well documented is the Embedded

SQL

> Guide, from Borland's IB 6 documentation set (EmbedSql.pdf -

google it, or

> get it from www.ibphoenix.com InterBase download page)
>

Thanks for your reply and various information references.. I've been
into transaction for 2 years now and still find those links useful.
Thanks for that.

Anyways, normally the create statement(or any ddl statement for that
matter) are auto-commit by nature. I checked the behavior in
firebird and it works this way only. In fact, the firebird offers
ways to 'disable' this behavior too (by doing a set AutoDDL, which
toggles the auto commit of ddl statements).

So, I'm not sure whether commit will help solve this problem.
Although I tried it (more out of curiosity) and got the same "object
is in use" error message (as expected).

Regards,
Suresh.K.V.