
Problem finding first record using CDaoRecordset
I checked the MSDN library and I could not find any suggestions about the
best way to open an MDB file and read the first record.
My method works fine the first time I call my function (after calling
myDaoRecordset.Open()).
However the next time I execute the code below I do not get the first
record. By the first record I mean the first row in my MDB file.
if(!myDaoRecordset.IsBOF())
myDaoRecordset.MoveFirst();
Any ideas about what I am doing wrong here?
For example, do I need to use some combination of the following:
m_strSort = ???
myDaoRecordset.m_strFilter = ???
myDaoRecordset.Requery();
Or, do I need to use SetBookmark(), GetLastModifiedBookmark()?
My Recordset type is Dynaset.
TIA.
Michael T.