cancel
Showing results for 
Search instead for 
Did you mean: 

Error: Either BOF or EOF is True, or the current record has been deleted

SOLVED
Occasional Contributor

Error: Either BOF or EOF is True, or the current record has been deleted

Hi,

 

I'm confused with this error. I used DDT to read From Begining To 1 of the excel file.

The excel file contain 1 line data, but still the error said "Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record".

 

I really need the solution asap. Thank you.

Tags (4)
1 ACCEPTED SOLUTION

Accepted Solutions
Occasional Contributor

Re: Error: Either BOF or EOF is True, or the current record has been deleted

I just add another data in the excel sheet. Means that the excel sheet contain two line of data and TestComplete throw no error anymore.


@TanyaGorbunova wrote:

Thanks everyone for the help!

@Nursyamim, have you managed how to resolve your question?


 

13 REPLIES 13
Highlighted
Community Hero

Re: Error: Either BOF or EOF is True, or the current record has been deleted

Please share your code.

Basically, what that error ususally indicates is that the result set of the DDT is empty. 


Robert Martin
[Community Expert Group]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Extensions available
Community Hero

Re: Error: Either BOF or EOF is True, or the current record has been deleted


what that error ususally indicates is that the result set of the DDT is empty. 

... and my guess that this may be because you specified that the first row of data set contains column names while they are absent.

 

Regards,
Alex
[Community Expert Group]
____
[Community Expert Group] members are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Postings made by [Community Expert Group] members
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
[Community Expert Group] signature is used with permission by SmartBear Software.
http://smartbear.com/forums/f83/t86934/community-experts/
================================
Community Hero

Re: Error: Either BOF or EOF is True, or the current record has been deleted

Sounds like your DDT loop may be one row off.  And yes, we'd like to see the code.

Super Contributor

Re: Error: Either BOF or EOF is True, or the current record has been deleted

Code please.

Occasional Contributor

Re: Error: Either BOF or EOF is True, or the current record has been deleted

 


@vthomeschoolmom wrote:

Code please.


Figure below shows the Excel file (EquipmentOverlay) used in my DDL. It contain 1 data only in line 2.
Excel file.png

 

Figure below shows the KeywordTest (DDL) where the error point to this line.

KeywordTest.png

 

Figure below shows my DDL that I used which Start record From the beginning and End record To record number 1.

Select Records.png

 

Occasional Contributor

Re: Error: Either BOF or EOF is True, or the current record has been deleted

@Marsha_R, You may see my new reply with some screenshots.

Community Hero

Re: Error: Either BOF or EOF is True, or the current record has been deleted

I suggest putting a breakpoint just before the loop and using debug to step through it.  Then you can see what it's really doing.

Occasional Contributor

Re: Error: Either BOF or EOF is True, or the current record has been deleted

 

Is this what you mean? Sorry, I'm new to TestComplete. Btw, this is the Dispatch_List_All test item.1.PNG

 

Community Hero

Re: Error: Either BOF or EOF is True, or the current record has been deleted

Yes, and you can use this to run the test one step at a time. 

https://support.smartbear.com/testcomplete/docs/testing-with/debugging/running/stepping-through.html

 

This way you can see exactly what's happening when.  

New Here?
Join us and watch the welcome video:
Join the September Hub-bub to show off, learn and win