我想得到字段里面最大的三个值,代码如下:
with adoquery1 do
begin
close;
sql.Clear;
sql.Add('select * from (select * from table order by hj) where rownum<=3 order by rownum desc');
self.ADOQuery1.Open;
end;
现在我想对三个最大值分别赋值也就是取出三个值,下面该怎样接着写?用fieldbyname('hj')也好像不行啊?
with adoquery1 do
begin
close;
sql.Clear;
sql.Add('select * from (select * from table order by hj) where rownum<=3 order by rownum desc');
self.ADOQuery1.Open;
end;
现在我想对三个最大值分别赋值也就是取出三个值,下面该怎样接着写?用fieldbyname('hj')也好像不行啊?
begin
ShowMessage( ADOQuery1.FieldByName('hj').AsString );
ADOQuery1.Next;
end;
ADOQuery1.Next;
b:=ADOQuery1.FieldByName('hj').AsInteger;
ADOQuery1.Next;
c:=ADOQuery1.FieldByName('hj').AsInteger;
ADOQuery1.Next;
然后引用楼上
a:=ADOQuery1.FieldByName('hj').AsInteger;
ADOQuery1.Next;
b:=ADOQuery1.FieldByName('hj').AsInteger;
ADOQuery1.Next;
c:=ADOQuery1.FieldByName('hj').AsInteger;
ADOQuery1.Next;