Board index » delphi » Closing a ADOQuery with no Records (Error EOF, BOF)

Sven Bayerl

Delphi Developer
Sat, 26 Apr 2003 03:00:00 GMT

Closing a ADOQuery with no Records (Error EOF, BOF)

Can someone Help!

I'm connecting to MSSQL2000 with Adocomponents and everything seems to work
fine except the following!

When I close a ADOQuery or ADODataSet that has no records i get the
following

Exception EOleException
Either Eof or BOF ist true, The current Record has been deleted. The
requested Operation requires a Current Record...

I've included Exception handling with no result, Nothing after works.

Greetings from Austria!

 
David B.

Delphi Developer
Sat, 26 Apr 2003 03:00:00 GMT

Re:Closing a ADOQuery with no Records (Error EOF, BOF)


Hi
if you use mdac 2.6 you need the Informal ado patch

Regards

David   agros...@arava.co.il

Quote
"Sven Bayerl" <S...@13oxn.at> wrote in message

news:8u9lg7$gks14@bornews.inprise.com...
Quote
> Can someone Help!

> I'm connecting to MSSQL2000 with Adocomponents and everything seems to
work
> fine except the following!

> When I close a ADOQuery or ADODataSet that has no records i get the
> following

> Exception EOleException
> Either Eof or BOF ist true, The current Record has been deleted. The
> requested Operation requires a Current Record...

> I've included Exception handling with no result, Nothing after works.

> Greetings from Austria!

Roge

Delphi Developer
Sat, 26 Apr 2003 03:00:00 GMT

Re:Closing a ADOQuery with no Records (Error EOF, BOF)


hi
i have the same problem with a filtered adoquery , the informal patch is
installed but the problem is still there.I have  reduilt the whole project
but nothing changes.

Thanks for your time

Shannon Broski

Delphi Developer
Sun, 27 Apr 2003 03:00:00 GMT

Re:Closing a ADOQuery with no Records (Error EOF, BOF)


I also have this problem.... I've install two informal ADO patches...  Are
there more than two?

Quote
"Sven Bayerl" <S...@13oxn.at> wrote in message

news:8u9lg7$gks14@bornews.inprise.com...
Quote
> Can someone Help!

> I'm connecting to MSSQL2000 with Adocomponents and everything seems to
work
> fine except the following!

> When I close a ADOQuery or ADODataSet that has no records i get the
> following

> Exception EOleException
> Either Eof or BOF ist true, The current Record has been deleted. The
> requested Operation requires a Current Record...

> I've included Exception handling with no result, Nothing after works.

> Greetings from Austria!

Shannon Broski

Delphi Developer
Sun, 27 Apr 2003 03:00:00 GMT

Re:Closing a ADOQuery with no Records (Error EOF, BOF)


The new update patch worked for me... It was confusing at first that the new
one still had the same ID as the old... I made it look like the same zip
file.  Oh well.  It works now...
Here's the URL I hit...
http://ww6.borland.com/codecentral/ccweb.exe/listing?id=14080

Quote
"Shannon Broskie" <sbros...@mediaone.net> wrote in message

news:3a09abd9$1_1@dnews...
Quote
> I also have this problem.... I've install two informal ADO patches...  Are
> there more than two?

> "Sven Bayerl" <S...@13oxn.at> wrote in message
> news:8u9lg7$gks14@bornews.inprise.com...
> > Can someone Help!

> > I'm connecting to MSSQL2000 with Adocomponents and everything seems to
> work
> > fine except the following!

> > When I close a ADOQuery or ADODataSet that has no records i get the
> > following

> > Exception EOleException
> > Either Eof or BOF ist true, The current Record has been deleted. The
> > requested Operation requires a Current Record...

> > I've included Exception handling with no result, Nothing after works.

> > Greetings from Austria!

Other Threads

1. AdoQuery.Active = false causes error when bof or eof

2. Eof/Bof error on Recordset.Close

3. ADO BOF or EOF error after empty records

4. ADOQuery-Find Prior getting EOF BOF exception

5. ERROR : Either BOF or EOF is True, or the current record has been deleted

6. Either BOF or EOF is True, or the current record has been deleted

7. Either BOF or EOF is True, or current record has been deleted

8. Either BOF or EOF is True, or Current record has been deleted

9. Either BOF or EOF is true or the current record has been deleted

10. Bof or Eof or current record is deleted problem