--- In ib-support@y..., "sdbeames" <s.beames@m...> wrote:

> --- In ib-support@y..., "Tomislav Avramovic" <tom@h...> wrote:
> > Hi Steve
> > You can use many connects in one script
> > __________
> > connect ........;
> > some DDL;
> > connect ........; // Fb will disconnect and connect
> > some DML;
> > __________
> > Tom
>
> Ahah! I think I was trying to disconnect first, and was getting

error

> messages. I'll give your way a try.
>
> Thank you,
> Steve

This doesn't seem to help me. I have a some DDL, a COMMIT, a CONNECT,
then some more DDL to drop a table, and I still get error messages
about an index being in use, unless I manually disconnect & reconnect
before running a second script that drops the table.

I'm using IB_SQL to run the scripts on FB1.0.

Any suggestions?
Thanks,
Steve