Hello Lee

I also am trying to understand the "Object <an object> is in use" error
message. Here are some pragmatic things to do to avoid or ovecome a
blocking cause which produces this error message.

1. If you are using an IB Administration tool (eg. Quickdesk, IBAdmin,
IBConsole) try closing the database in the tool, closing the administration
program and try again. This has worked in some cases, in my work (eg. when
using the administrator to insert default values for a column)

2. Try looking in the administrators "Show dependencies for the table" to
see if any dependency is blocking the change. Eg. If you are trying to
delete Table STAT and procedure PROC_STAT uses STAT you will get a
"dependency" error message when trying to drop STAT. There may be cases
where you can get an "Object in use" error as well. Can't think of an
example quickly.

3. Try closing your database, backing up the database and restoring the
database. Why? My unconfirmed hypothesis about why this sometimes works is
... some IB administration programs insert incorrect "stuff" into IB system
tables and a backup and restore cleans up the errors. I have had this happen
and have not explored it further.

(I've been developing with IB and tools for 7 months and I am no expert.)

Best regards,

Russell

----- Original Message -----
From: "Leeway" <lee@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, July 24, 2001 2:48 AM
Subject: [IBO] Dropping a table


> I want to drop a table called STAT
> First I make sure that the table is closed
> Then I try to delete the table
> But I get a error 'object STAT is in use'
> I closed the table, how can it still be in use ?
> Is there a sql command I can use to make shure the table is free for
> dropping ?
>
> Lee
>
>
> procedure TStat.DeleteTableStat;
> begin
> try
> QTIB_Stat.Close;
> except;
> end;
>
> try
> RunSql.SQL.Clear;
> RunSql.SQL.Add('drop table STAT');
> RunSql.ExecSQL;
> except;
> end;
> end;
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>