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

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

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

Unfortunately, you do have to disconnect then reconnect before running
the second script. Any time you touch an index and to be able to drop
the index, drop a related index(foreign key) or drop a table related to the
index, you need to disconnect then reconnect. I have to do
this if I'm dropping many foreign keys or tables containing foreign
keys.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)