Subject | Dropping a table |
---|---|
Author | Leeway |
Post date | 2001-07-23T14:48:59Z |
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;
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;