You can avoid this error, if you ensure that all connections to databases
are dropped. Thats a funny approach in a multi user environment :)

Try to work around by clearing this temp table only. Use a special key field
to "assign" records to a special user/connection only. In this case more
then one user is able to work with this temp table w/o hassle.

Mit freundlichem Gruss & Best Regards

Andreas Pohl
apohl@...
www.ibp-consult.com

----- Original Message -----
From: "Leeway" <lee@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, July 26, 2001 10:19 AM
Subject: [IBO] Table in use


> I still got a problem with dropping of a table.
> I got the 'in use' error.
> This happens 5 times out of 10, so not always.
> I hate it when this happens.
> But now I got another problem, even if I use the try..except methode,
> The user still got the error on the screen.
> I beleved that a try..except prevented that the error shows when
> running the program.
> What am I missing ?
>
> procedure TStat_00.DeleteTableStat;
> begin
> try
> DM.QTIB_Stat.IB_Connection.Disconnect;
> DM.QTIB_Stat.IB_Connection.Connect;
> except;
> end;
>
> try
> DM.RunSql.SQL.Clear;
> DM.RunSql.SQL.Add('drop table STAT');
> DM.RunSql.ExecSQL;
> except;
> end;
> end;
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>