Re: Data Queries Sporadically Return Empty Recordsets

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 02/17/03 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Mon, 17 Feb 2003 06:24:51 -0700

In your ADO code, check for an empty recordset before trying
to work with records or fields in the recordset.

-Sue

On Sat, 15 Feb 2003 13:58:15 -0800, "Taylor"
<info@corporatecounsel.org> wrote:

>I need to get hold of the fix for this. Can anyone email
>me the fix.
>
>This is the return to the database
>
>ADODB.Field error '800a0bcd'
>
>Either BOF or EOF is True, or the current record has been
>deleted. Requested operation requires a current record.
>
>/directory/test.asp, line 123

Relevant Pages

  • Re: ADO problem
    ... Earlier versions failed to escape all characters ... > the recordset to get a XML DOM Object. ... > Are there any service packs available to fix this problem. ...
    (microsoft.public.vb.general.discussion)
  • Re: ADO problem
    ... Earlier versions failed to escape all characters ... > the recordset to get a XML DOM Object. ... > Are there any service packs available to fix this problem. ...
    (microsoft.public.vb.database.ado)
  • Re: too few parameters
    ... Here's a good example of what Arno R and his band of dimwiteers are ... <Sorry about the multiple threads. ... I was so tied up trying to fix this and ... >> You seem to have opened a recordset but not moved to a record. ...
    (microsoft.public.access.formscoding)
  • Re: command not working
    ... The implication is that the Recordset of the form is based on a query that's ... Unless you can fix that, ...
    (microsoft.public.access.formscoding)
  • Re: Checking to see of recordset is Null
    ... I think referring to a recordset as Null is incorrect - [possibly ... ' fix A) ... ' DAO Code ... ' ADO code ...
    (microsoft.public.access.reports)