Subject Re: [firebird-support] object is in use problems
Author Lucas Franzen
vbj34 schrieb:

> Hello,
>
> I am currently working on a project where I create temp tables in a
> Firebird database, insert large number of records into the tables,
> copy records from temp tables to permanent tables, then drop the temp
> tables. At the end of the process there is >150000 records inserted.
> The problem is I get object is in use errors as shown below when
> removing some of the temp tables, although I made sure no other
> process can connect to the DB during the entire operation.

Which components do you use within your client?

Have you ever tried to disconnect from and reconnect to your database
before deleting the tables?

(I know that with e.g. IBO I have to do in certain cases when (after)
issueing DDL)

Luc.