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

[Nursyamim]

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.

[tristaanogre]

Please share your code.

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

[AlexKaras]

---

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.

[Marsha_R]

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

[vthomeschoolmom]

Code please.

[Nursyamim]

---

@vthomeschoolmom wrote:

Code please.

---

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

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

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

[Nursyamim]

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

[Marsha_R]

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]

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

[Marsha_R]

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.