Subject | Table in use |
---|---|
Author | Leeway |
Post date | 2001-07-26T08:19:19Z |
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;
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;