with dm_jshpkchz do
begin
qry_hpkchz.last;
while not qry_hpkchz.bof do
begin
tbl_hpkchz.Append;
for i:=0 to dm_jshpkchz.qry_hpkchz.fieldcount-1 do
begin
tbl_hpkchz.fields[i].asstring:=qry_hpkchz.fields[i].asstring;
end;
tbl_hpkchz.post;
qry_hpkchz.prior;
end;
end; //dm
dm_jshpkchz.qry_hpkchz.close;
另外如果是大型数据库用就行了
insert into table1(...) select (...) from table1 where 唯一条件即可