Posted on 2002-05-04
I have an ado recordset populated with records. I am stepping through the recordset backwards and deleting each record.
The first time I attempt to decrement the loop (after deleting my first record) it skips a record and I end up at the third record. This never happens again throughout the process. The result is every record gets deleted except for the second record.
sql = "Select * from tblmeetings where recurringmeetingid = " & mRecurringMeetingID
Set MeetingRS = New Recordset
MeetingRS.Open sql, DBConnect, adOpenDynamic, adLockOptimistic
If Not MeetingRS.EOF Then
Do While Not MeetingRS.BOF