Board index » delphi » Either EOF or BOF is True -- Error in Delphi 6

Either EOF or BOF is True -- Error in Delphi 6

I read though the previous issues on this error an found that Brian Bushay of (TeamB) said this would be fixed in Delphi 6.

"Yes Delphi 6 will not have the BOF/EOF problem introduced by MDAC 2.6" Brian Bushay of (TeamB)

I still get the error when I try to access a deleted record of an ADODataSet after turing Filtered on and setting FilterGroups = fgPendingRecords.  I want to temporaraly undelete the current record so I can access the data values and then re-delete it from the record set.

Here is a small snipit from my code...Please Help.

{*** First check for deleted records ***}
AAR_DM.RqstPhoneMail.FilterGroup := fgPendingRecords;
AAR_DM.RqstPhoneMail.Filtered := True;
while not(AAR_DM.RqstPhoneMail.EOF) do
begin
  if (rsDeleted in AAR_DM.RqstPhoneMail.RecordStatus) then
  begin
    { Undelete the record so we can read the data }
    AAR_DM.RqstPhoneMail.CancelBatch(arCurrent); -- ERROR OCCURS HERE --
    try
      { Copy the values into update paramenters }
      qryInsert.Parameters.ParamByName('PHONE_MAIL').Value := AAR_DM.RqstPhoneMail.Fields[0].Value;
       .
       .
       .
    finally
       { Re-delete the record }
       AAR_DM.RqstPhoneMail.Delete;
    end;
  end;
  AAR_DM.RqstPhoneMail.Next;
end;

 

Re:Either EOF or BOF is True -- Error in Delphi 6


Applied UP1 or UP2?

Re:Either EOF or BOF is True -- Error in Delphi 6


Quote
"Clive Crocker" <Cli...@cmc.uk.com> wrote:
>Applied UP1 or UP2?

I had not, but I now have and I still get the error.

Re:Either EOF or BOF is True -- Error in Delphi 6


Quote
>"Yes Delphi 6 will not have the BOF/EOF problem introduced by MDAC 2.6" Brian Bushay of (TeamB)

>I still get the error when I try to access a deleted record of an ADODataSet after turing Filtered on and setting FilterGroups = fgPendingRecords.  I want to temporaraly undelete the current record so I can access the data values and then re-delete it from the record set.

This is not the same issue.
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Re:Either EOF or BOF is True -- Error in Delphi 6


I am also experiencing this error, only it is in Delphi 5 Enterprise
with Update Pack 1 and ADOExpress Update 2. I have been getting it
simply while scrolling through hierarchical/nested datasets returned
by MSDataShape. I posted an extremely simple project showing how to
duplicate the error, but have gotten no responses. This post is
intended both as a show of solidarity and as a cry for help. Free us
from the BOF/EOF yoke of terror!

Adam

Re:Either EOF or BOF is True -- Error in Delphi 6


Brian Bushay TeamB <BBus...@Nmpls.com> wrote:

Quote

>>"Yes Delphi 6 will not have the BOF/EOF problem introduced by MDAC 2.6" Brian Bushay of (TeamB)

>>I still get the error when I try to access a deleted record of an ADODataSet after turing Filtered on and setting FilterGroups = fgPendingRecords.  I want to temporaraly undelete the current record so I can access the data values and then re-delete it from the record set.
>This is not the same issue.
>--
>Brian Bushay (TeamB)
>Bbus...@NMPLS.com

Sorry Brian, I thought it was the same.  Do you have a answer for my problem?

Re:Either EOF or BOF is True -- Error in Delphi 6


Quote
>Sorry Brian, I thought it was the same.  Do you have a answer for my problem?

You will have to check your other message thread.
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Other Threads