Attempting to scroll before or after the data

[floatingkent]

trying to access the db of access using VC++, my main view class is derived from CRecordView, I think the recordset should be always available to use without having to call m_pSet->Open().

I call m_pSet->MoveFirst() in the view class, get the error like

Attempting to scroll before or after the data

and I tested the m_pSet->IsBOF() , which returns true!

I suspect that the resultset is empty or closed somehow. Please help, I will wait online

[jwalto1]

Hi floatingkent,

Perhaps a MFC Sample application will help you understand your task.

See http://msdn.microsoft.com/library/de...mfc_enroll.asp.

Also, a typical enumeration is below.

Jeff

if ( ! m_pSet->IsOpen() )
    m_pSet->Open();

if( m_pSet->IsBOF() )
{
    AfxMessageBox( "Table is Empty!");
    return;
}
m_pSet->MoveFirst();
while ( ! m_pSet->IsEOF() )
{
    CString str = m_pSet->m_Description ;
    
    m_pSet->MoveNext();
}