Using CDatabase to retrieve the number of records available...
Posted on 2003-12-09
I have an application that uses CDatabase and CRecordset.
I connect to the database using
And send the SQL query using
rs.Open("SELECT * FROM DATA WHERE SERIALNO='123';");
Now, I can use...
for( ; ! rs.IsEOF(); rs.MoveNext() )
To retrieve the data, but is it possible to determine how many records have been generated for the specified query?
GetRecordCount() appears to get only the number of records that have been accessed?
Also, if there are no records to view, I can use CDatabase::ExecuteSQL(...) but assuming the query was an update, how do I find out how many records have been affected???
Thanks for any help,