Ask a Question

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

SOLVED
Nursyamim
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.

13 REPLIES 13
tristaanogre
Esteemed Contributor

Please share your code.

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


Robert Martin
[Hall of Fame]
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
Vegas Thrill Rider
Extensions available


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 Champion]
____
[Community Champions] 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. Posts made by [Community Champions]
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.
The [Community Champion] signature is assigned on quarterly basis and is used with permission by SmartBear Software.
https://community.smartbear.com/t5/Community-Champions/About-the-Community-Champions-Program/gpm-p/252662
================================

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

Code please.

Nursyamim
Occasional Contributor

 


@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

 

Nursyamim
Occasional Contributor

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

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.

Nursyamim
Occasional Contributor

 

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

 

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.  

cancel
Showing results for 
Search instead for 
Did you mean: