I am using ADODB connection for connecting to DB25 database. I have created a Recordset object and used its "Filter" method to filter the records. After applying filter, I got some record count. Based upon that, I tried to navigate through the records but I am getting "Either EOF or BOF has been reached". I also used "MoveFirst" method to make it point to the first record. Please provide some alternate solution to overcome this issue.
"Either EOF or BOF has been reached" message comes when there are no records present in the recordset. Please check that your filter is returning any rows or not. It might have been the case that your filter condition is not satisfying any rows from DB. Use following code to avoid this error.
If not RecSet.EOF
Do until RecSet.EOF
'Do your transactions here...
By default the record position stays in first position when you open the recordset.
Thanks for your comments. I used the recordset's method "RecordCount" to get the number of retrieved records.
Eventhough I am getting the count > 0, I am getting "Either EOF or BOF has been reached" message.