Subject RE: [IBO] Re: performance issue when adding tables
Author Jason Wharton
> > BUT - (jason on board?) if you have "CacheStatementHandles" set to
> > true, the Handle of the "cache-update" Statement is still
> > valid, and a "drop table " Statement will fail.
> >
>
> i must correct: SchemaCaching is NOT responsible for "drop table"
> failure. It was a freed TIB_Query that still has handles
> open. This is
> topic of the "object %o is in use" thread.

Schema caching and the caching of statement handles are two entirely
separate things. Please clarify exactly what is going on and preferrably
please send me a sample application that duplicates your problem so that I
can take a look at it.

Thanks,
Jason Wharton