var s:string; begin with ADOQuery1 do begin Close; SQL.Clear; SQL.Add('SELECT max(Field) FROM Table'); Prepare; Open; end; s:=ADOQuery1.FieldByName('Field').asstring; end; :)最碰的方法~~~~~~~
select Max(Field) as fieldmax from tableiFieldMax = query.fieldbyname("fieldmax").AsInteger
var s:string; begin 改一下: with ADOQuery1 do begin Close; SQL.Clear; SQL.Add('SELECT max(Field) field FROM Table'); Prepare; Open; end; s:=ADOQuery1.FieldByName('Field').asstring; end;
var s:string; begin 改一下: with ADOQuery1 do begin Close; SQL.Clear; SQL.Add('SELECT max(Field) field FROM Table'); Prepare; Open; end; s:=ADOQuery1.Fields(0).asstring; end;
s:string;
begin
with ADOQuery1 do
begin
Close;
SQL.Clear;
SQL.Add('SELECT max(Field) FROM Table');
Prepare;
Open;
end;
s:=ADOQuery1.FieldByName('Field').asstring;
end;
:)最碰的方法~~~~~~~
s:string;
begin
改一下:
with ADOQuery1 do
begin
Close;
SQL.Clear;
SQL.Add('SELECT max(Field) field FROM Table');
Prepare;
Open;
end;
s:=ADOQuery1.FieldByName('Field').asstring;
end;
s:string;
begin
改一下:
with ADOQuery1 do
begin
Close;
SQL.Clear;
SQL.Add('SELECT max(Field) field FROM Table');
Prepare;
Open;
end;
s:=ADOQuery1.Fields(0).asstring;
end;