Subject Jaybird 'object in use' error adding ref integrity constraint
Author Rashid Motala
Thank you for your prompt reply Blas.

While the bug you describe may be a bug in FB/IB, it does not fully
explain this scenario. The script in question fails to run using Jaybird
- forever. You can shutdown the app after it fails, shutdown Interbase,
restart everything, and let the app start with this particular script -
it will fail, it always fails.

Regards,
Rashid.

> ؟Do you create the table CARD_QUERY in the previous SQL statement?

> It seems this is an old error in IB (some years old). If you create a
> table, and inmediately try to create a table that references to the
first
> one, sometimes depending on the database status this error is
returned.

> Recently I read a mail in the firebird-devel list about this bug,
> finally someone found the problem (Nicolay Samofatov 14 Sept). Perhaps
in
> the near future the problem can be solved.

> Regards
> Blas Rodriguez Somoza