FIX: CFile Exception: badSeek, OS error information = -1

   CSomeRecordset rs;
   rs.Open();
   rs.Edit();
   rs.IsFieldDirty(NULL);
   rs.m_field1="somevalue";
   rs.Update();
   rs.Close();
				

void CRecordset::MarkForUpdate()
{
   ASSERT_VALID(this);
   ASSERT(m_hstmt != SQL_NULL_HSTMT);

   // Must have already stored field values in memfile
   ASSERT(m_pmemfile != NULL);

   CFieldExchange fx(CFieldExchange::MarkForUpdate, this);
   m_pmemfile->SeekToBegin();

   ASSERT(m_par != NULL);
   delete m_par;
   m_par = NULL;
   m_par = new CArchive(m_pmemfile, CArchive::load);
   fx.m_par = m_par;

   DoFieldExchange(&fx);
}
				

RESOLUTION

The solution is to move the SeekToBegin() function to a position following the delete of the CArchive that is attached to the file.

To do this, copy four functions (Update(),UpdateInsertDelete(), IsFieldDirty(), and MarkForUpdate()) from DBCORE.CPP to your CRecordset .CPP file. The Update() function is virtual so by copying these functions to your recordset class, you will guarantee that your new (instead of old) MarkForUpdate() function is called.

The only change you need to make to the code is to the MarkForUpdate() function. Place the code that deletes the archive before the call to SeekToBegin() as shown here:

void CSomeRecordset::MarkForUpdate()
{
   ASSERT_VALID(this);
   ASSERT(m_hstmt != SQL_NULL_HSTMT);

   // Must have already stored field values in memfile
   ASSERT(m_pmemfile != NULL);

   ASSERT(m_par != NULL);
   delete m_par;
   m_par = NULL;

   CFieldExchange fx(CFieldExchange::MarkForUpdate, this);
   m_pmemfile->SeekToBegin();

   m_par = new CArchive(m_pmemfile, CArchive::load);
   fx.m_par = m_par;

   DoFieldExchange(&fx);
}
				

Again, copy the Update(), UpdateInsertDelete(), and IsFieldDirty() functions from the code in DBCORE.CPP to functions of the same name in your new CRecordset-derived class.