Thanks Jason.
That is the answer. I just close the connection to the temporary
tables and open it again and all can be dropped.
Dave.

--- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> There are times that you need to close all connections to flush out
> internally cached prepares. This is a general InterBase problem and
not an
> IBO problem, from what I can tell.
>
> Sometimes I don't catch the connection in the application being
connected at
> design time.
>
> HTH,
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: "Dave Bullar" <comesailing@b...>
> To: <IBObjects@y...>
> Sent: Saturday, May 05, 2001 3:06 PM
> Subject: [IBO] 'Table in use'
>
>
> > Help !
> > I have a problem with trying to drop a temporary table. Sometimes
it is
> successful but often it is 'in use' so will not drop. I have been
through
> all the code, and checked that all queries are closed, that they are
> 'unprepared' and that the transaction involved is 'committed'. I
thought,
> that must do it. Nothing is open in design mode.
> >
> > Is there any way of telling what is holding the table 'in use' ?
Or any
> help in generally diagnosing the problem would be welcome.
> > Thanks
> > Dave.
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >