令 令狐冲001 Unregistered / Unconfirmed GUEST, unregistred user! 2006-09-22 #1 我想把 sql.add('select sum(a),sum(b) from xxxx') 得出的结果赋值给两个变量x1,x2,怎么用?
B blackg Unregistered / Unconfirmed GUEST, unregistred user! 2006-09-22 #2 with AdoQuery1 do begin Close; Sql.Clear; Sql.add('select sum(a) as T1,sum(b) as T2 from xxxx'); Open; end; x1:=AdoQuery1.FieldByName('T1').AsInteger; x2:=AdoQuery1.FieldByName('T2').AsInteger; 是这个意思吧!
with AdoQuery1 do begin Close; Sql.Clear; Sql.add('select sum(a) as T1,sum(b) as T2 from xxxx'); Open; end; x1:=AdoQuery1.FieldByName('T1').AsInteger; x2:=AdoQuery1.FieldByName('T2').AsInteger; 是这个意思吧!