procedure TForm1.Button1Click(Sender: TObject);
begin
adoquery2.SQL.Add('insert into wanchengyewu select * from yewu where id=1');
adoquery2.ExecSQL;
adoquery1.SQL.Add('delete from yewu where id=1');
adoquery1.ExecSQL;
end;
end.我这么写的,它说我是FROM子句语法错误
我打包了
http://guanggaoren.com/test/test.exe相关帖子
http://expert.csdn.net/Expert/topic/1309/1309456.xml?temp=.3520319
begin
adoquery2.SQL.Add('insert into wanchengyewu select * from yewu where id=1');
adoquery2.ExecSQL;
adoquery1.SQL.Add('delete from yewu where id=1');
adoquery1.ExecSQL;
end;
end.我这么写的,它说我是FROM子句语法错误
我打包了
http://guanggaoren.com/test/test.exe相关帖子
http://expert.csdn.net/Expert/topic/1309/1309456.xml?temp=.3520319
adoquery1.SQL.clear先
有吗?
否则不会出错的啊
具体的语法参考原来的帖子。
象你这样写的话,wanchengyewu和yewu这两个表的字段个数要一样、类型要兼容
且要一一对应,如果含有自增加类型的字段,就不能这样写。要这样写:
insert into wanchengyewu(Field1,Field2,Field3) selelct Field1,field2
,field3 from yewu where id=1上面的几个字段要一一对应,类型要兼容。还有就是 调用adoquery.sql.add之前先要Clear
begin
adoquery2.close;
adoquery2.sql.clear;
adoquery2.SQL.Add('insert into wanchengyewu(id,jiedanren) selelct id,jiedanren from yewu where id=1');
adoquery2.ExecSQL;
adoquery1.close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('delete from yewu where id=1');
adoquery1.ExecSQL;
end;
end.
还是不对:(
begin
adoquery2.close;
adoquery2.sql.clear;
adoquery2.SQL.Add('insert into wanchengyewu(id,jiedanren) (selelct id,jiedanren from yewu where id=1)');
adoquery2.ExecSQL;
adoquery1.close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('delete from yewu where id=1');
adoquery1.ExecSQL;
end;
end.
and u try
insert into ... select ... 语句的倡议一下:
在数据库版,提问的时候说明是什么数据库好不好?!更不要在没有说清楚问题的情况下满世界找高手,高手就是你自己。
既方便解答的人判断,也加快你自己的问题的解决!
是ACCESS,mdb数据库
procedure TForm1.Button1Click(Sender: TObject);
begin
adoquery2.close;
adoquery2.sql.clear;
adoquery2.SQL.Add('insert into wanchengyewu(jiedanren) (selelct jiedanren from yewu where id=1)');
adoquery2.ExecSQL;
adoquery1.close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('delete from yewu where id=1');
adoquery1.ExecSQL;
end;
insert into table [(field1...fieldn)] values .....
insert into table [(field1...fieldn)] values .....
->
'delete yewu where id=1'
insert into .........selelct ..... from .... where .......
这种格式的拉