2,498
社区成员
发帖
与我相关
我的任务
分享
var
sqlstr:string;
i:integer;
begin
ADOConnection.GetTableNames(ListBox1.Items,False);
sqlstr := '';
if listbox1.Items.Count>0 then
begin
for i:=0 to listbox1.Items.Count-1 do
sqlstr := sqlstr +'delete from '+listbox1.Items[i]+';';
end;
with adoquery1 do
begin
sql.Add(sqlstr);
execsql;
end;
end;
var
sqlstr:string;
begin
sqlstr := 'delete from table1;'+
'delete from table2;'+
'delete from tablen;';
with adoquery1 do
begin
sql.Add(sqlstr);
execsql;
end;
end;