# Error : Either BOF or EOF are true, or the current record was deleted

**URL:** https://www.finalbuilder.com/forums/t/error-either-bof-or-eof-are-true-or-the-current-record-was-deleted/2835
**Category:** Bugs
**Created:** [May 22, 2007, 1:53am UTC](https://www.finalbuilder.com/forums/t/error-either-bof-or-eof-are-true-or-the-current-record-was-deleted/2835 "2007-05-22T01:53:34Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![dmirapalheta](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/dmirapalheta/32/67_2.png) [@dmirapalheta](https://www.finalbuilder.com/forums/u/dmirapalheta)
#### Post date: [May 22, 2007, 1:53am UTC](https://www.finalbuilder.com/forums/t/error-either-bof-or-eof-are-true-or-the-current-record-was-deleted/2835/1 "2007-05-22T01:53:34Z")

</div>

&nbsp; Just a little problem I have a long time with the ADO Dataset Iterator that time didn't let me complain about that. When a query returns no row it complains about BOF or EOF being true, I had to ignore failure in actions that may return no records but this trapped me yesterday, when my ADO dataset iterator was supposed to expose a real error.

&nbsp; I think this shouldn't be an error just as 0 files found in file iterator isn't an error.

&nbsp; Best Regards,

&nbsp; DM

---

<div class="post-metadata">

### Author: ![angus](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/a/b3f665/32.png) [@angus](https://www.finalbuilder.com/forums/u/angus)
#### Post date: [May 23, 2007, 1:51am UTC](https://www.finalbuilder.com/forums/t/error-either-bof-or-eof-are-true-or-the-current-record-was-deleted/2835/2 "2007-05-23T01:51:21Z")

</div>

Hi Daniel,  
  
You’re right, this is a bug. The iterator doesn’t always fail if no rows are found, but it does do it sometimes. I’ve fixed the bug, the fix will be available in the next test build. Just for completeness’ sake, I’ve added a new feature called “Fail if no rows are found”, although it defaults to off.  
  
I’ll let you know when a test build with the fix is available.  
  
Regards,  
  
Angus

---

<div class="post-metadata">

### Author: ![dmirapalheta](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/dmirapalheta/32/67_2.png) [@dmirapalheta](https://www.finalbuilder.com/forums/u/dmirapalheta)
#### Post date: [May 23, 2007, 1:39am UTC](https://www.finalbuilder.com/forums/t/error-either-bof-or-eof-are-true-or-the-current-record-was-deleted/2835/3 "2007-05-23T01:39:27Z")

</div>

Thank’s Angus. I’ll wait for it.  
  
Regards,  
DM

---

<div class="post-metadata">

### Author: ![angus](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/a/b3f665/32.png) [@angus](https://www.finalbuilder.com/forums/u/angus)
#### Post date: [May 24, 2007, 3:01am UTC](https://www.finalbuilder.com/forums/t/error-either-bof-or-eof-are-true-or-the-current-record-was-deleted/2835/4 "2007-05-24T03:01:02Z")

</div>

Hi Daniel,  
  
The build is ready:  
  
[https://www.finalbuilder.com/downloads/finalbuilder/550/FB550\_242.exe](https://www.finalbuilder.com/downloads/finalbuilder/550/FB550_242.exe)  
  
Please let us know how you go.  
  
Regards,  
  
Angus

---

<div class="post-metadata">

### Author: ![dmirapalheta](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/dmirapalheta/32/67_2.png) [@dmirapalheta](https://www.finalbuilder.com/forums/u/dmirapalheta)
#### Post date: [May 25, 2007, 1:53am UTC](https://www.finalbuilder.com/forums/t/error-either-bof-or-eof-are-true-or-the-current-record-was-deleted/2835/5 "2007-05-25T01:53:15Z")

</div>

Seams to have worked fine. Thanks Angus.  
  
Best regards,  
DM

---

<div class="post-metadata">

### Author: ![romualdo](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/r/e9a140/32.png) [@romualdo](https://www.finalbuilder.com/forums/u/romualdo)
#### Post date: [May 21, 2013, 1:50am UTC](https://www.finalbuilder.com/forums/t/error-either-bof-or-eof-are-true-or-the-current-record-was-deleted/2835/6 "2013-05-21T01:50:51Z")

</div>

This error came back to occur in version 7.0.0.2232!

---

<div class="post-metadata">

### Author: ![nevar](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/n/c4cdca/32.png) [@nevar](https://www.finalbuilder.com/forums/u/nevar)
#### Post date: [May 22, 2013, 6:44am UTC](https://www.finalbuilder.com/forums/t/error-either-bof-or-eof-are-true-or-the-current-record-was-deleted/2835/7 "2013-05-22T06:44:55Z")

</div>

Hi Romualdo,   
  
 Your build is available.   
  
 [http://downloads.finalbuilder.com/downloads/finalbuilder/700/FB700\_2286.exe](http://downloads.finalbuilder.com/downloads/finalbuilder/700/FB700_2286.exe)   
  
 Please let us know how you go.   
  
 Regards,   
 Jason

---

<div class="post-metadata">

### Author: ![romualdo](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/r/e9a140/32.png) [@romualdo](https://www.finalbuilder.com/forums/u/romualdo)
#### Post date: [June 4, 2013, 2:34am UTC](https://www.finalbuilder.com/forums/t/error-either-bof-or-eof-are-true-or-the-current-record-was-deleted/2835/8 "2013-06-04T02:34:22Z")

</div>

Thank you very much!
