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

Jim Covington

Delphi Developer

Mon, 28 Jun 2004 02:07:33 GMT

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

I am using ADO stored procedures against a Microsoft SQL database using D5.
I use the same
StoredProcedure component to run multiple MS stored procedures. After
running the first SP (it works fine)
when I execute a SP.Close to run the second SP, I get the above error.

Does anyone have a clue?

Jim

Tim Haye

Delphi Developer

Mon, 28 Jun 2004 03:39:23 GMT

Re:Either BOF or EOF is true or the current record has been deleted

I have the same problem except when I try and close a query. The funny thing
is that I can run the program just fine at work, but at home I get this
error. I reloaded the ADO controls (from MS) but that didn't do any good.

I'd like a solution also. :)

Tim

Quote

"Jim Covington" <jwcov...@telapex.com> wrote in message

news:3c3c86e6_2@dnews...

Quote

> I am using ADO stored procedures against a Microsoft SQL database using
D5.
> I use the same
> StoredProcedure component to run multiple MS stored procedures. After
> running the first SP (it works fine)
> when I execute a SP.Close to run the second SP, I get the above error.

> Does anyone have a clue?

> Jim

Edwin Walke

Delphi Developer

Mon, 28 Jun 2004 04:30:57 GMT

Re:Either BOF or EOF is true or the current record has been deleted

You might have 2.6 at home.

Probably the EOF/BOF error that MDAC 2.6 causes.
If so, you need the ADOExpress update pack 2.
See http://www.borland.com/devsupport/delphi/mdac26.html

Edwin

Quote

"Tim Hayes" <t...@deap.org> wrote in message news:3c3c9c6b$1_2@dnews...
> I have the same problem except when I try and close a query. The funny
thing
> is that I can run the program just fine at work, but at home I get this
> error. I reloaded the ADO controls (from MS) but that didn't do any good.

> I'd like a solution also. :)

> Tim

> "Jim Covington" <jwcov...@telapex.com> wrote in message
> news:3c3c86e6_2@dnews...
> > I am using ADO stored procedures against a Microsoft SQL database using
> D5.
> > I use the same
> > StoredProcedure component to run multiple MS stored procedures. After
> > running the first SP (it works fine)
> > when I execute a SP.Close to run the second SP, I get the above error.

> > Does anyone have a clue?

> > Jim

Alain Thiffaul

Delphi Developer

Mon, 28 Jun 2004 10:20:03 GMT

Re:Either BOF or EOF is true or the current record has been deleted

Had the same problem and it was indeed the MDAC. The ADP update pack 2
fixed it.

Quote

"Edwin Walker" <ewal...@summitnational.com> wrote in message

news:3c3ca8d6$1_2@dnews...

Quote

> You might have 2.6 at home.

> Probably the EOF/BOF error that MDAC 2.6 causes.
> If so, you need the ADOExpress update pack 2.
> See http://www.borland.com/devsupport/delphi/mdac26.html

> Edwin

> "Tim Hayes" <t...@deap.org> wrote in message news:3c3c9c6b$1_2@dnews...
> > I have the same problem except when I try and close a query. The funny
> thing
> > is that I can run the program just fine at work, but at home I get this
> > error. I reloaded the ADO controls (from MS) but that didn't do any
good.

> > I'd like a solution also. :)

> > Tim

> > "Jim Covington" <jwcov...@telapex.com> wrote in message
> > news:3c3c86e6_2@dnews...
> > > I am using ADO stored procedures against a Microsoft SQL database
using
> > D5.
> > > I use the same
> > > StoredProcedure component to run multiple MS stored procedures. After
> > > running the first SP (it works fine)
> > > when I execute a SP.Close to run the second SP, I get the above error.

> > > Does anyone have a clue?

> > > Jim

Brian Bushay Team

Delphi Developer

Mon, 28 Jun 2004 13:18:41 GMT

Re:Either BOF or EOF is true or the current record has been deleted

Quote

>I am using ADO stored procedures against a Microsoft SQL database using D5.
>I use the same
>StoredProcedure component to run multiple MS stored procedures. After
>running the first SP (it works fine)
>when I execute a SP.Close to run the second SP, I get the above error.

Have you installed ADOExpress Update 2?
This error is generated by MDAC 2.6 and the Unpatched version of ADOExpress

http://www.borland.com/devsupport/delphi/mdac26.html
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Tim Haye

Delphi Developer

Wed, 30 Jun 2004 03:17:28 GMT

Re:Either BOF or EOF is true or the current record has been deleted

I do have 2.6, and come to think of it, I might not have installed the ado
update. I have the delphi update.

Thank you I'll try that when I get home.

Quote

> You might have 2.6 at home.

> Probably the EOF/BOF error that MDAC 2.6 causes.
> If so, you need the ADOExpress update pack 2.
> See http://www.borland.com/devsupport/delphi/mdac26.html

> Edwin

Other Threads

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

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

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

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

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

6. Bof or Eof or current record is deleted problem

7. Either BOF or EOF is True

8. Delphi 7 Informix Either BOF or EOF is True

9. either bof or eof is true .... error

10. 'Either BOF or EOF is true'