//题目出的好象不是很清楚 query1.moveby(n); if query1.fieldbyname('xx').value<>nil then begin query2.close; query2.sql.clear; query2.sql.add(select * from table where name:=a'); query2.sql.ParamByName('a').value:=query1.fieldbyname('xx').value; query2.open; if not query2.eof() then begin query1.edit; query1.filedbyname('xx').value:=query2.fieldbyname('xx').value; query1.post; end; end;
已经检索出query1,也知道n,两个query的结果都有个相同的字段
query2.sql.add('select * from table where name:=a'); sorry 漏了'
ain2000:moveby是移动到第n行,还是移动n行啊,假如我想在query1的结果里从第一行到最后一行挨个判断,是不是for i:=1 to last query1.moveby(1);
query1.moveby(n);
if query1.fieldbyname('xx').value<>nil then
begin
query2.close;
query2.sql.clear;
query2.sql.add(select * from table where name:=a');
query2.sql.ParamByName('a').value:=query1.fieldbyname('xx').value;
query2.open;
if not query2.eof() then
begin
query1.edit;
query1.filedbyname('xx').value:=query2.fieldbyname('xx').value;
query1.post;
end;
end;
sorry 漏了'
query1.moveby(1);