请问adoquery中要清空一个表，这个语句怎么写？(50分)

zycjf · 2001-06-02

是一个access表 comm
with adoquery1 do
begin
active:=false;
sql.clear;
sql.add('delete comm');
active:=true;
end;
这样好像不行

阿器 · 2001-06-02

try this:
delete from comm

fu_xiang_yu · 2001-06-02

最白痴的方法是：用个循环语句从第一个记录开始依次删除
应该很简单啊

张剑波 · 2001-06-02

1: drop yourtable
2: insert into yourtable from yourtable_struction

张剑波 · 2001-06-02

sorry:
1:drop table comm
2: select * into comm from comm_struction;
comm_struction是个空表，和comm结构一样。

scorpions · 2001-06-02

with adoquery1 do
begin
close;
sql.clear;
sql.add('delete from comm');
execsql;
end;

HeBaisong · 2001-06-02

with adoquery1 do begin
close;
sql.clear;
sql.add('delete from comm');
prepared;
try
execsql;
except
showmessage('清空失败');
end;
end;

HORNEY · 2001-06-03

execsql嘛

Qiuliang · 2001-06-03

DeleteRecords(arAll);

book523 · 2001-06-03

with adoquery1 do
begin
close;
sql.clear;
sql.add('delete from comm'');
execsql;
end;

江维 · 2001-06-03

with adoquery1 do
begin
close;
sql.clear;
sql.add('truncate table comm');
execsql;
end;

zycjf · 2001-06-03

多人接受答案了。