使用ADOCommand更新Sybase数据库表时遇到问题,给出正确答案一定给分
while ...
begin
ADOCommand.CommandText := 'insert into table1......';
ADOCommand.Execute;
ADOCommand.CommandText := 'update table1 set ....';
ADOCommand.Execute;
...
end;
此循环执行若干次后报错:(每次报错均为执行update时)
SQL Server has run out of LOCKS...
似乎是ADOCommand占用了资源而示释放.
请教高手,如何解决此问题.