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