敬请各位高手指点哈,我要删除表中的所有记录,代码如下,但为什么删不完,总要剩几条?谢谢了!ADOTable2.Active:=True;
ADOTable2.Edit;
while not ADOTable2.Eof do
begin
ADOTable2.Delete;
ADOTable2.Next
end;
ADOTable2.Edit;
while not ADOTable2.Eof do
begin
ADOTable2.Delete;
ADOTable2.Next
end;
ADOTable2.Edit;
ADOTable2.first;
while not ADOTable2.Eof do
begin
ADOTable2.Delete;
ADOTable2.Next
end;
while not ADOTable2.Eof do ADOTable2.Delete;delete后记录指针会自动移动到下一条的,不用next了
delete from tablename
或
truncate table tablename