Either BOF or EOF is True - MDAC 2.8 - Delphi 6 SP3 - SQL2000 - Win XP



I've search all the threads on this issue and all of them seem to refer only
to Delphi 5 and MDAC 2.5.

I'm Using Win XP SP2 (which include MDAC 2.8), Delphi 6 SP3, and SQL2000, so
I believe I have all the updated covered.

When I open a ADODataSet in BatchUpdate mode, Append a record, and then
"Post" it to memory/batch -- Everything is fine. But if I perform a
ADODataSet.CancelUpdates I still get the "Either BOF or EOF is True" error.
However, if commit the inserts to the database first using
ADODataSet.UpdateBatch and then make changes to the record and perform a
ADODataSet.CancelUpdates, everything is fine. It only happens when I start
with an empty recordset and try to CancelUpdates before and UpdateBatch.


.



Relevant Pages

  • D5 ADO ORDINAL_POSITION always zero with MDAC 2.7
    ... D5 with ADOExpress, under WXP vs. W2K, MDAC 2.7 vs. MDAC earlier ... I use Connection.OpenSchema to retrieve table & field data from an ADO ... work-around in the Delphi code for TCustomADODataSet.UpdateIndexDefs: ...
    (borland.public.delphi.database.ado)
  • Re: Good News!
    ... PIII derived laptop chip) and 1gb of ram. ... not been able to understand posts like this that refer to Delphi being ...
    (borland.public.delphi.non-technical)
  • Re: Crashes on XP Home
    ... > I believe the version that still works was compiled with Delphi 6. ... I don't have a copy of WinXP Home Edition but AFAIK it does not include MDAC ... as part of it's standard components. ... application supplier installed it as part of app installation. ...
    (borland.public.delphi.non-technical)
  • Re: MDAC & MS Jet 4.0
    ... ADO and JET, you will need to make sure MDAC 27 or above and the MS Access ... > I have developed a database application with Borland Delphi 7. ...
    (microsoft.public.data.ado)
  • Re: Is anything spectacular going to happen around Delphi anymore?
    ... > your own analysis is applicable to all users of Delphi is arrogant, ... What assertion? ... If you want to refer to what I've said ...
    (borland.public.delphi.non-technical)