ab.mdb==>query1 cd.mdb==>query2 两个库的结构完全一样 我用ODBC连接了
begin
cmd:='insert into cd..dfsdl(M,C,S) select M,C,S from ab..dfsdl where S=0' ;
query2.Close;
query2.sql.clear;
query2.sql.add(cmd);
query2.ExecSQL;
query1next;
end;
但是插入时报错!还有插入完毕后,如何将S=0改为S=1,然后断开与QUERY2地连接。请高手们指点一下。
begin
cmd:='insert into cd..dfsdl(M,C,S) select M,C,S from ab..dfsdl where S=0' ;
query2.Close;
query2.sql.clear;
query2.sql.add(cmd);
query2.ExecSQL;
query1next;
end;
但是插入时报错!还有插入完毕后,如何将S=0改为S=1,然后断开与QUERY2地连接。请高手们指点一下。
2.
var
sql: String;
begin
sql := 'insert into dfsdl(M,C,S) select M, C, ''1'' '
+ ' from dfsdl in ''ab:\B.mdb'' where s = ''0''';
ADOConnection1.Connected := True;
ADOConnection1.Execute(sql);
end;
--
cmd:='insert into cd..dfsdl(M,C,S) select M,C,1 from ab..dfsdl where S=0' ;
query1.edit;
query1.FieldByName('aaa').AsString := query2.FieldByName('aaa').AsString ;
query1.next;
query2.next;
query1.post;