ADO patch for D5? EOF BOF error.

From: "Mike Martin" <mikem@xxxxxxx>
Date: Wed, 25 Jan 2006 01:58:50 -0700

Yes, I'm still in the dark ages. Does anyone know if there's an ADO patch
foir Delphi 5. I have installed the Delphi5 Update pack from Borland, but it
did not solve the problem.

After looping through the results of a simple select query (tADOQuery),
myquery.close or myquery.free produces the "Either BOF or EOF is true, or
current record deleted."

Certainly, EOF is true, since I just looped throught the rows.

I can almost cure this, if I use myquery.prior before using myquery.close.
But the error still occurs on an empty recordset or an a recordset with only
one row.

.

Follow-Ups:
- Re: ADO patch for D5? EOF BOF error.
  - From: Steve Zimmelman
- Re: ADO patch for D5? EOF BOF error.
  - From: Graham Plain
- Re: ADO patch for D5? EOF BOF error.
  - From: Jacob Havkrog

Prev by Date: BOF or EOF error -MSAccess
Next by Date: Re: ADO patch for D5? EOF BOF error.
Previous by thread: BOF or EOF error -MSAccess
Next by thread: Re: ADO patch for D5? EOF BOF error.
Index(es):
- Date
- Thread

Relevant Pages

Re: .BOF and .EOF are lying!
... BOF and EOF properties would have a specific value at a certain time, ... the first record in the Recordset ...
(microsoft.public.access.gettingstarted)
Re: Empty "If Me.Recordset Is Nothing Then" clause causes runtime error 3021 (Access 2003)
... "If you delete the last remaining record in the Recordset ... I have some unresolved issues with requery/BOF/EOF, ... >> BOF and EOF are set by a MOVE command. ...
(microsoft.public.access.formscoding)
Re: Empty "If Me.Recordset Is Nothing Then" clause causes runtime error 3021 (Access 2003)
... "If you delete the last remaining record in the Recordset ... I have some unresolved issues with requery/BOF/EOF, ... >> BOF and EOF are set by a MOVE command. ...
(microsoft.public.access.forms)
Re: .BOF and .EOF are lying!
... You haven't shown us the specific circumstance when the BOF and EOF ... those for forms' recordset or recordsetclone. ... correct count for me without having to use .MoveLast. ...
(microsoft.public.access.gettingstarted)
Re: Find a specific record with two criteria
... >> You can use a Filter on the recordset, or you can nest your Finds if the ... >> If Not .EOF Then ... >> Note, though, that even if you could use multiple fields in the Find method, ... >>> This code is fine for one criteria, but if more than one criteria, it ...
(microsoft.public.access.modulesdaovba)