SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 5 of 5
  1. #1
    Junior Member
    Join Date
    Jun 2011
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Recordset object moves to EOF

    Hi,

    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.

  2. #2
    Senior Member
    Join Date
    Jul 2008
    Location
    Mumbai,India
    Posts
    145
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Recordset object moves to EOF

    Can you share the code you are using?
    @;-
    To err is to CODERS , to TEST is divine

    Keshava

  3. #3
    Junior Member
    Join Date
    Jan 2012
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Recordset object moves to EOF

    "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...
    'Msgbox RecSet.Fields(0)
    RecSet.movenext
    Loop
    End if

    By default the record position stays in first position when you open the recordset.

    Hope it helps.

  4. #4
    Junior Member
    Join Date
    Jun 2011
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Recordset object moves to EOF

    Hi All,

    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.

  5. #5
    Super Member QAGanesh's Avatar
    Join Date
    Sep 2010
    Posts
    1,898
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Recordset object moves to EOF

    can u share the code!!
    Thanks,
    Ganesh Iyer
    Winds of Change

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 10.00%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 01:48 PM.

Copyright BetaSoft Inc.