with dbsmqrytmp do
begin
Close;
SQL.Text :=
Format('select max(itemindex) maxindex from cnitem where groupindex=%d',
[groupindex]);
Open;
while not Eof do
begin
result := fieldbyname('maxindex').AsInteger;
Next;
end;
end;
数据库里没有记录,结果返回0.可我用数据库查询结果是null啊
begin
Close;
SQL.Text :=
Format('select max(itemindex) maxindex from cnitem where groupindex=%d',
[groupindex]);
Open;
while not Eof do
begin
result := fieldbyname('maxindex').AsInteger;
Next;
end;
end;
数据库里没有记录,结果返回0.可我用数据库查询结果是null啊
.AsInteger會把null變成0