Re: CDatabase CRecordset - How to get the number of rows?




"David++" <David@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:63FB861B-E7A4-408C-A964-A4DD36A98B16@xxxxxxxxxxxxxxxx
> Hi Roy,
>
> This is the code I have so far -
>
> CRecordset rs(&db);
>
> rs.Open(CRecordset::forwardOnly,"SELECT * FROM
Records",CRecordset::readOnly);
>

NO! -- the SQL command should be "Select Count(*) FROM Recrds"

regards
Roy



.



Relevant Pages