PRB: CRecordset::Move(0) Asserts with skipDeletedRecords Option

MORE INFORMATION

Steps to Reproduce Behavior

The following code reproduces this:

   CMyRecordset  RSet ;
   RSet.Open (AFX_DB_USE_DEFAULT_TYPE, NULL,
      CRecordset::skipDeletedRecords) ;
   RSet.Move (0) ;
				

The Move(0) call results in an assertion.

Move(0) refreshes the recordset data for the current row from the open database cursor. This is useful in a multi-user environment when the recordset is opened using the dyanset or dynamic open types. Other users may change the database after the current row has been retrieved. Move(0) refreshes the recordset row data so that it reflects the current contents of the database. If it is necessary to use Move (0), open the recordset without the skipDeletedRecords option.

Another effect of the Move() function is that it switches out of Edit/Add New mode. To prevent this from happening, use the CancelUpdate() member function. This refreshes the row data from the local cache without hitting the database cursor.