Hello Bob

If, when you try to drop the temporary table, there is a transaction open
which uses the table then the "Table is in use". Could this be the problem?
Without your code I cannot fully understand your logic in steps 1...6.

Regards

Russell Belding

----- Original Message -----
From: <bobzirbel@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, July 25, 2001 2:51 PM
Subject: [IBO] Object in use when dropping table


> I have some code that uses TIB_grid, TIB_Query and TIBOQuery with D5
> and IB6.
> The code drops and creates a temporary table, populates the table
> from records selected in the grid, opens a simple query on the
> temporary table and prints a report.
>
> All works fine - once! The second time the code is executed it
> errors with 'Object in use' on the drop table.
>
> I have eliminated all extraneous code and narrowed the cause down to
> the last query. It's close doesn't seem to free the temporary
> table. The sequence is as follows:
>
> 1. Drop table.
> 2. Create table.
> 3. Populate table.
> 4. Select * from table.
> 5. Open.
> 6. Close.
> 1. Drop table - error Object in use!
>
> If steps 4, 5 & 6 are eliminated it works fine.
>
> Does anyone have any idea what I doing wrong?
>
> Any help would be appreciated.
>
> Thanks and regards
> Bob
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>