Subject | Re: [firebird-support] object is in use problems |
---|---|
Author | Lucas Franzen |
Post date | 2004-04-08T18:59:13Z |
vbj34 schrieb:
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.
> Hello,Which components do you use within your client?
>
> 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.
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.