用ADOQuery来 with ADOQuery1 do begin close sql.clear; sql.add(format('delete from %s',[Delete_tablename])); execsql; end;
请问black,这两句加在哪里?
这两句替换你的所有程序 procedure TForm1.Button4Click(Sender: TObject); begin try adotable1.open; adotable1.EmptyTable; except on E:Exception do ShowMessage(E.Message); end; end;
query1.sql.add('drop table Name');
query1.exesql;
adotable1.Post;
adotable1.next;
with ADOQuery1 do
begin
close
sql.clear;
sql.add(format('delete from %s',[Delete_tablename]));
execsql;
end;
procedure TForm1.Button4Click(Sender: TObject);
begin
try
adotable1.open;
adotable1.EmptyTable;
except
on E:Exception do
ShowMessage(E.Message);
end;
end;