with ADOQUERY1 do
begin
sql.Clear ;
sql.Add('select max(BJBH) from TABLE1');
Active:=true;
end;
然后怎么获得这个值呢?谢谢!
begin
sql.Clear ;
sql.Add('select max(BJBH) from TABLE1');
Active:=true;
end;
然后怎么获得这个值呢?谢谢!
调试欢乐多
这个是值。
begin
sql.Clear ;
sql.Add('select max(BJBH) as ddd from TABLE1');
Active:=true; sql.fieldbyname(ddd).vaule
end;
with ADOQUERY1 do
begin
sql.Clear ;
sql.Add('select max(BJBH) as maxstr from TABLE1');
Active:=true;
end;
str1:=adoqurey1.fieldbyname('maxstr').asstring;
最后这一句,可能有所不同,没有测试!
begin
sql.Clear ;
sql.Add('select aa=max(BJBH) from TABLE1');
Active:=true;
end;adoquery1.fieldbyname('aa').value;//注意设定列名如果不设('select max(BJBH) from TABLE1'):adoquery1.field[0].value
begin
sql.Clear ;
sql.Add('select max(BJBH) as maxstr from TABLE1');
end;
adoquery1.open;
str1:=adoqurey1.fieldbyname('maxstr').asstring;
xylyge(很想学好):你的'maxstr'哪来的啊1???
begin
Active:= false;
sql.Clear;
sql.Add('select top 1 BJBH from TABLE1 order by BJBH DESC');
Active:=true;
end;
str:=adoqurey1.fieldbyname('BJBH').asstring;
FROM TABLE1
WHERE (fieldname =(SELECT MAX(fieldname) FROM TABLE1))
VAR
A:INTEGER;
begin
sql.Clear ;
sql.Add('select max(BJBH) AS MX from TABLE1');
A =ADOQUERY1.FIELDBYNAME('MX').ASINTEGER;
end;
xylyge(很想学好):你的'maxstr'哪来的啊1???