ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('select count(*) as renshu from toneclass where zongfen>=100 and zongfen<10 group by class order by class');
ADOQuery1.Open;
showmessage(inttostr(ADOQuery1.Recordset.RecordCount));
showmessage的结果为0,为什么呢?个人觉得用了count()函数,返回的记录条数至少应该为1的呀
ADOQuery1.SQL.Add('select count(*) as renshu from toneclass where zongfen>=100 and zongfen<10 group by class order by class');
ADOQuery1.Open;
showmessage(inttostr(ADOQuery1.Recordset.RecordCount));
showmessage的结果为0,为什么呢?个人觉得用了count()函数,返回的记录条数至少应该为1的呀
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('select * from toneclass where zongfen>=100 and zongfen <10 group by class order by class');
ADOQuery1.Open;
showmessage(inttostr(ADOQuery1.Recordset.RecordCount));
有大于等于100,小于10的数吗?
这样当然没记录