2,498
社区成员
发帖
与我相关
我的任务
分享
ADOQuery.SQL.Text := 'insert into MyTable(na,ma) as A select na,ma from [;database=d:\money.mdb;pwd=你的密码].MyTable as B where A.A not in (select B.A from B);
ADOQuery.SQL.Text := 'insert into MyTable(na,ma) as A select na,ma from MyTable in '+QuotedStr('d:\money.mdb')+ ' as B where A.A not in (select B.A from B);
var
i : integer;
adoquery1.close;
AdoQuery1.sql.text := 'select * from Data1';
AdoQuery1.open;
adoquery2.close;
AdoQuery2.sql.text := 'select * from Data1 where 1=2';
AdoQuery2.open;
if not AdoQuery1.isEmpty then begin
with AdoQuery1 do while not eof do begin
adoquery2.close;
AdoQuery2.sql.text := 'select * from Data1 where 主鍵 = '+Fields[ 主建].Value;
AdoQuery2.open;
if AdoQuery2.isEmpty then begin
AdoQuery2.Append;
for I := 0 to AdoQuery1.fieldCount -1 do
begin
AdoQuery2.fields[i].value := Fields[i].value;
end;
end;
Next;
end;
end;
ADOQuery.SQL.Text := 'insert into MyTable as A select * from MyTable in '+QuotedStr('d:\money.mdb')+ ' as B where A.A not in (select B.A from B);
假定ADOQuery连接c:\money.mdb,表名为MyTable
ADOQuery.SQL.Text := 'insert into MyTable select * from MyTable in '+QuotedStr('d:\money.mdb');
意思是将'd:\money.mdb'中MyTbale表中的数据插入到'c:\money.mdb'中的MyTable中
SQL.Text := 'insert into A select * from B in '+QuotedStr('d:\money.mdb');
var
i : integer;
adoquery1.close;
AdoQuery1.sql.text := 'select * from Data1';
AdoQuery1.open;
adoquery2.close;
AdoQuery2.sql.text := 'select * from Data1 where 1=2';
AdoQuery2.open;
if not AdoQuery1.isEmpty then begin
with AdoQuery1 do while not eof do begin
AdoQuery2.Append;
for I := 0 to AdoQuery1.fieldCount -1 do
begin
AdoQuery2.fields[i].value := Fields[i].value;
end;
Next;
end;
end;