Objective Grid: Record set loading

Article ID: 492
Last updated: 25 Apr, 2018
Article ID: 492
Last updated: 25 Apr, 2018
Revision: 3
Views: 1711
Posted: 12 Jan, 2001
by Meltreger B.
Updated: 25 Apr, 2018
by Meltreger B.

Problem

 


Does the record window deal with virtualizing the result set? In other words, is the entire result set loaded into the grid when the query is executed?

 

 


Cause

 


 

 


Action

 


Yes, only the current record is loaded. All changes in the current record are stored in the buffer and when you move to a new record, the buffer is flushed to the recordset.

The grid determines the row count by calling the CRecordset::GetRecordCount() member. This member function only returns the number of records seen in the record set and will grow when you scroll to the end of the recordset. Take a look at the MFC Class Reference for the CRecordset::GetRecordCount() member.

You might also determine the record count with a SQL Query like "Select Count(*) from table" and return the value determined through this SQL Query by overriding CGXBrowserGrid::OnGetRecordCount().

This article was:   Helpful | Not helpful
Report an issue
Article ID: 492
Last updated: 25 Apr, 2018
Revision: 3
Views: 1711
Posted: 12 Jan, 2001 by Meltreger B.
Updated: 25 Apr, 2018 by Meltreger B.

Others in this category