Re: BOF or EOF error -MSAccess Fixed

It seems to be fixed for the moment, not that I understand it. The problem
does not occurr when the recordcount is 0, so this seems to have fixed the
problem. I guess it doesn't want me to close the query when eof is true.

if q1.recordcount > 0 then
q1.first.
q1.close;

I did see a slight difference in MSAccess driver versions under ODBC,
between my Win2K and WinXP computers. I don't don't know if ODBC has
anything to do with ADO.

"Mike Martin" <mikem@xxxxxxx> wrote in message
news:43d72586@xxxxxxxxxxxxxxxxxxxxxxxxx
> On Windows XP computers, my application receives this eOleException when
> when performing MyADOQuery.close (or .free). This does not happen on Win2K
> computers.
>
> Either BOF or EOF is true, or the current record has been deleted.
>
> It's a simple select query, but eof is definitely true. The error occurs
> after looping through the rows.
>
>


.

Relevant Pages

  • Re: BOF or EOF error -MSAccess Fixed
    ... That's probably the patch I can't find, as I do still use D5. ... I guess it doesn't want me to close the query when eof is true. ... >> I did see a slight difference in MSAccess driver versions under ODBC, ... >> between my Win2K and WinXP computers. ...
    (borland.public.delphi.database.ado)
  • Re: BOF or EOF error -MSAccess Fixed
    ... There was a bug in D5's ADO that was ... I guess it doesn't want me to close the query when eof is true. ... > I did see a slight difference in MSAccess driver versions under ODBC, ... > between my Win2K and WinXP computers. ...
    (borland.public.delphi.database.ado)
  • File management
    ... global empName, previousYTD, payRate, hoursWorked, recordCount, ... eof, payFile, \ ... payFileUpdated, newYTD, currentPay ...
    (comp.lang.python)
  • Re: Check on empty record set in VBA
    ... >> EOF and BOF to be sure, and that there are some unique circumstances ... .RecordCount is more reliable in DAO and broken ... With ADO, rs.EOF will never be false if there are 0 records in the ... the .RecordCount works only with a KeySet cursor ...
    (comp.databases.ms-access)
  • Re: Kombifeld Formular: Neuer Eintrag + Abgleich mit Quelltabelle
    ... behaupte BOF liefert nicht in allen Sitationen das richtige Ergebnis, die Prüfung auf Recordcount = 0 hingegen schon. ... Hier ein bisschen Code, der zeigt, das die Prüfung auf BOF=True durchaus nicht immer das erwartete liefert, RecordCount hingegen schon: ... BOF=False, EOF = False, RecordCount = 1 ...
    (microsoft.public.de.access)