--- In ib-support@y..., Helen Borrie <helebor@d...> wrote:

> At 01:32 PM 25-09-01 +1200, you wrote:
> >I have a situation where I delete all records in a table and then

I

> >drop the index on that table.
> >The sql is
> >
> >delete from Table;
> >drop index Table_Index;
> >
> >but because I have done delete before dropping the index the index
> >is in use and I cannot drop it. How do I get around it.
>
> Did you commit the deletes before trying to drop the index?

Yes, I'm using TIBOQuery and AutoCommit on the linked transaction is
set to true, and I'm assigning the the two statements in a procedure
as

qry.sql.text := 'delete from Table;';
qry.ExecSQL;

qry.sql.text := 'drop index Table_Index;';
qry.ExecSQL;