BOF/EOF Exception

Steve Hunt

unread,

Dec 3, 2001, 2:33:22 PM12/3/01

to

When I try to use the simple code below:

begin
login.FindFirst;
While not login.Eof do begin
// .........
login.FindNext;
end;
messagedlg('Got to Message',mtwarning, [mbOK],0);
end;

I get the dreaded EOLEException error - 'Either Bof or Eof is True, or the
current record has been deleted. Request operation requires a current
record."

The messageDlg line is never reached. The table is transversed until the
final record is reached, before the error appears.

"login" is a TADODataSet connected to an Access 2000 table.

What am I doing wrong??? Can I turn this off somehow???

Steve Hunt

Edwin Walker

unread,

Dec 3, 2001, 12:42:15 PM12/3/01

to

Download and install the ADOExpress
(http://www.borland.com/devsupport/delphi/mdac26.html)

"Steve Hunt" <sh...@tnscale.com> wrote in message news:3c0bb728$1_2@dnews...

Raphael Soares de Moraes

unread,

Dec 3, 2001, 2:20:19 PM12/3/01

to

Go to http://www.inprise.com/devsupport/delphi/ and you will see Borland's
MDAC2.6 solution
for this problem. It's a Update Pack for Delphi.

Raphael.
rso...@rsi.com.br

"Steve Hunt" <sh...@tnscale.com> escreveu na mensagem
news:3c0bb728$1_2@dnews...

Steve Hunt

unread,

Dec 3, 2001, 4:34:16 PM12/3/01

to

I am using Delphi 6 and have tried the ADOExpress Update for Delphi 5. This
problem occurs even in Delphi 5 with the upgrade installed.

"Edwin Walker" <ewa...@summitnational.com> wrote in message
news:3c0bb9cd$1_2@dnews...

Edwin Walker

unread,

Dec 3, 2001, 2:49:36 PM12/3/01

to

Steve,

Make sure you recompile your whole app, and any DLL's that uses ADOExpress.

Edwin

"Steve Hunt" <sh...@tnscale.com> wrote in message news:3c0bd375$1_2@dnews...

Brian Bushay TeamB

unread,

Dec 3, 2001, 11:02:15 PM12/3/01

to

>begin
> login.FindFirst;
> While not login.Eof do begin
> // .........
> login.FindNext;
> end;
> messagedlg('Got to Message',mtwarning, [mbOK],0);
>end;
>
>I get the dreaded EOLEException error - 'Either Bof or Eof is True, or the
>current record has been deleted. Request operation requires a current
>record."
>

>What am I doing wrong??? Can I turn this off somehow???

Looks to me like bad code. FindNext doesn't set Eof

use

login.FindFirst;
While not login.Eof do begin
// .........

login.Next;

end;
messagedlg('Got to Message',mtwarning, [mbOK],0);

or

login.FindFirst;
While true do begin
// .........
if not login.FindNext then
Break

end;
messagedlg('Got to Message',mtwarning, [mbOK],0);

--
Brian Bushay (TeamB)
Bbu...@NMPLS.com