赋值提交就可以了
赋值如下
query1.first;
while not query1.eof do
query2.append;
for lp := 0 to query1.fields.count - 1 do
query2.fieldbyname(query1.fields[lp]).asvariant := query1.fieldbyname(query1.fields[lp]).asvariant;
query2.post;
query1.next;
end;
以上也适合Blob字段赋值
赋值提交就可以了
赋值如下
query1.first;
while not query1.eof do
query2.append;
for lp := 0 to query1.fields.count - 1 do
query2.fieldbyname(query1.fields[lp]).asvariant := query1.fieldbyname(query1.fields[lp]).asvariant;
query2.post;
query1.next;
end;
以上也适合Blob字段赋值