with Adoquery1 do begin Close; SQL.Clear; SQL.Add('insert into B select * from A'); SQL.Add('TRUNCATE TABLE A'); ExecSQL; Close; end;
with Adoquery1 do begin Close; SQL.Clear; SQL.Add('insert into B select * from A'); SQL.Add('delete from TABLE A'); ExecSQL; Close; end;
while ADOQuery1.count>=0 do begin with Adoquery1 do begin Close; SQL.Clear; SQL.Add('insert into B select * from A'); SQL.Add('delete from TABLE A'); ExecSQL; Close; end; end;这样试试我也没有测试过
with data.ADOQuery13 do begin close; sql.Clear; SQL.Add('insert into sykp select * from lsb'); sql.Add('delete from lsb'); execsql; end; 为什么提示from子句语法错误
或用sql语句
insert into
as select
select * form A
union delect A
begin
Close;
SQL.Clear;
SQL.Add('insert into B select * from A');
SQL.Add('TRUNCATE TABLE A');
ExecSQL;
Close;
end;
begin
Close;
SQL.Clear;
SQL.Add('insert into B select * from A');
SQL.Add('delete from TABLE A');
ExecSQL;
Close;
end;
begin
with Adoquery1 do
begin
Close;
SQL.Clear;
SQL.Add('insert into B select * from A');
SQL.Add('delete from TABLE A');
ExecSQL;
Close;
end;
end;这样试试我也没有测试过
begin
close;
sql.Clear;
SQL.Add('insert into sykp select * from lsb');
sql.Add('delete from lsb');
execsql;
end;
为什么提示from子句语法错误