INFO: GetRecordCount May Not Return Correct Number of Records
Article ID: 165563
Article Last Modified on 12/2/2003
APPLIES TO
- Microsoft Visual C++ 4.0 Standard Edition
- Microsoft Visual C++ 4.1 Subscription
- Microsoft Visual C++ 4.2 Enterprise Edition
- Microsoft Visual C++ 5.0 Enterprise Edition
- Microsoft Visual C++ 6.0 Enterprise Edition
- Microsoft Visual C++ 4.2 Professional Edition
- Microsoft Visual C++ 5.0 Professional Edition
- Microsoft Visual C++ 6.0 Professional Edition
- Microsoft Visual C++ 6.0 Standard Edition
This article was previously published under Q165563
SUMMARY
CDaoRecordset::GetRecordCount is not guaranteed to return the correct
number of rows for a table-type recordset even if you call this function
after calling MoveLast().
MORE INFORMATION
You can call CDaoRecordset::GetRecordCount to find out how many records in
a recordset have been accessed. GetRecordCount does not indicate how many
records are contained in a dynaset-type or snapshot-type recordset until
all records have been accessed. To force the last record to be accessed,
call the MoveLast function.
The value of GetRecordCount from a table-type recordset reflects the
approximate number of records in the table.
To get an accurate record count, open a dynaset- or snapshot-type recordset
and then do a MoveLast. Table-type recordsets will be accurate immediately
after the database has been compacted or repaired.
REFERENCES
Visual C++ Help; search on: CDaoRecordset::GetRecordCount
Keywords: kbdatabase kbusage KB165563