select max(字段) as a from 表 然后用adoquery.fieldbyname('a').asinteger将数据取出。
adoqry.sql.add('select max(fieldname) as maxID from tablename') MaxID:=ADoqry.fieldbyname('maxID').asinteger;
var re:integer; adoquery1.close; adoquery1.sql.clear; adoquery1.sql.add('select max(fieldname) as maxs from table'); adoquery1.open; re:=adoquery1.fields[0].value;
query1.close; query1.sql.clear; query1.sql.add('select max(gdgz) from jzg'); query1.execsql; zz:=query1.field[0].asinteger;
select max(字段) as m from 表adoquery.fieldbyname('m').asinteger
然后用adoquery.fieldbyname('a').asinteger将数据取出。
MaxID:=ADoqry.fieldbyname('maxID').asinteger;
re:integer;
adoquery1.close;
adoquery1.sql.clear;
adoquery1.sql.add('select max(fieldname) as maxs from table');
adoquery1.open;
re:=adoquery1.fields[0].value;
query1.sql.clear;
query1.sql.add('select max(gdgz) from jzg');
query1.execsql;
zz:=query1.field[0].asinteger;