SQL.Add('SELECT formula,val(DMAF) as i from 配方诊断表 where 1=1 and formula ='''+Combobox3.Text+''' and formula ='''+Combobox4.Text+''''); 这个语句中。我想把val（DMAF）作为一个变量。查询各个字段的值。请问如何给所要查询的变量字段赋值呢。
就是说表中有好多字段。如何查询各个字段的值。后面where条件不变。如何实现 sqlstr:='insert into Machine (MACHINEID,USERID) values (:Pmach,:puser)';
with ADOQuery1 do begin Active := false; SQL.Clear; SQL.Add('SELECT * from 配方诊断表 where ......'); Active:=true; First; while not EOF do begin for i:=0 to Fields.Count-1 do begin //通过循环取各字段的值 //Show Fields[i].value end; Next; end;
