PRB: CDaoRecordView Bookmark Members Invalid After Requery()

RESOLUTION

To avoid the problem, re-initialize the CDaoRecordView bookmark members to indicate that they are not valid bookmark values following any Requery() on the related CDaoRecordset. The following example shows how this might be done in a CDaoRecordView-derived class's OnMove() function:

   BOOL CMyRecordView::OnMove(UINT nIDMoveCommand)
   {
      CDaoRecordset* pRecordset = OnGetRecordset();
      if (m_bAddMode)
      {
         if (!UpdateData())
            return FALSE;
         try
         {
            pRecordset->Update();
         }
         catch (CDaoException* e)
         {
            AfxMessageBox(e->m_pErrorInfo->m_strDescription);
            e->Delete();
            return FALSE;
         }

         pRecordset->Requery();

         m_varBookmarkCurrent = 1L;   // <<- re-initialize
         m_varBookmarkFirst =         // <<- the bookmark
            m_varBookmarkLast = 0L;   // <<- member variables!

         UpdateData(FALSE);
         m_bAddMode = FALSE;
         return TRUE;
      }
      else
      {
         return CDaoRecordView::OnMove(nIDMoveCommand);
      }
   }
				

If you call Requery() in any other case from your CDaoRecordView-derived class, you should also perform this re-initialization.