完善:
procedure TForm1.Button1Click(Sender: TObject);
var dd:string;dd1:string;
begin
adoquery1.SQL.Clear ;
adoquery1.SQL.Add('select * from ttu');
adoquery1.Open;
while not adoquery1.Eof do
begin
adoquery2.Close;
adoquery2.SQL.Clear;
dd1:='select '+ adoquery1.FieldByName('A').AsString+' as ff';
adoquery2.SQL.Add(dd1);
adoquery2.Open;
dd:=adoquery2.FieldByName('ff').AsString;
showmessage(dd);
adoquery1.Edit;
adoquery1.FieldByName('B').AsString:=dd;
adoquery1.UpdateRecord;
adoquery1.Next;
end ;
示例:
var dd:string;dd1:string;
begin
adoquery1.SQL.Clear ;
adoquery1.SQL.Add('select * from ttu');
adoquery1.Open;
while not adoquery1.Eof do
begin
adoquery2.Close;
adoquery2.SQL.Clear;
dd1:='select '+ adoquery1.FieldByName('A').AsString+' as ff';
adoquery2.SQL.Add(dd1);
adoquery2.Open;
dd:=adoquery2.FieldByName('ff').AsString;
showmessage(dd);
adoquery1.Next;