再次请问:
var
i: integerquery1.sql.clear;
query1.sql.add('select max(ShipmentNo) from HandBook');
query1.open;
i := query1.fields[0].asinteger;query1.close;
结果:越界。
var
i: integerquery1.sql.clear;
query1.sql.add('select max(ShipmentNo) from HandBook');
query1.open;
i := query1.fields[0].asinteger;query1.close;
结果:越界。
i := query1.fieldbyname('ShipmentNo').asinteger;
不可以。
再试
i := query1.fields[0].asinteger;
提示:
list index out of bound(0)
i := query1.fieldbyname('ShipmentNo').asinteger;
query1.sql.add('select isNULL(max(ShipmentNo),0) as ShipmentNo from HandBook');//*********
i := query1.fieldbyname('ShipmentNo').asinteger;