Either BOF or EOF is True,

Akram · March 1st, 2011, 02:55 AM

hi to all there,

i have a problem with this error :

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

/arabic/index.asp, line 0

disel2010 · March 1st, 2011, 08:53 AM

Hi Akram,

you give only very little information, so I have to guess here.

Are you trying to loop through an ADODB.recordset in a while loop or something?
Then please first check if you have records returned by testing eof, like

Code:

Set oRS=Server.CreateObject("ADODB.recordset")
oRS.execute "SELECT * FROM employees", oConn
if not oRS.eof then
   While not oRS.eof
      ' Do something with the data here
      oRS.movenext
   Loop
end if

Akram · March 1st, 2011, 09:07 AM

Dear disel thanks alot yes your right ......problem is solved...

Quote:

Originally Posted by disel2010

Hi Akram,

you give only very little information, so I have to guess here.

Are you trying to loop through an ADODB.recordset in a while loop or something?
Then please first check if you have records returned by testing eof, like

Code:

Set oRS=Server.CreateObject("ADODB.recordset")
oRS.execute "SELECT * FROM employees", oConn
if not oRS.eof then
   While not oRS.eof
      ' Do something with the data here
      oRS.movenext
   Loop
end if