Performing Bulk Fetches with GetRows and GetRowsEx

The dbDAO classes support the GetRows method for retrieving multiple records in one call. Like the Visual Basic version, the GetRows method returns the data as variants.

The GetRowsEx method is a performance improvement by dbDAO and MFC DAO to avoid the necessity of retrieving all data as variants and then converting to native types. The GetRowsEx method does not exist in Visual Basic DAO.

Important The underlying ICDAORecordset::GetRows method might not be supported in future versions of DAO; however, the MFC and dbDAO classes that use this method will continue to be supported.