Opening Recordset requires a current record?

Results 1 to 2 of 2

Thread: Opening Recordset requires a current record?

  1. #1
    Bill J. Guest

    Default Opening Recordset requires a current record?

    ADODB.Field error &#039 800a0bcd&#039 <BR><BR>Either BOF or EOF is True, or the current record has been deleted; the operation requested by the application requires a current record. <BR><BR>/news.asp, line 62<BR><BR><BR>No problem, right? I mean, this is a pretty elementary error that we&#039ve all gotten at one point or another. Well, to help illustrate my befuddlement, I present to you line 62.<BR><BR><BR>RS3.Open "SELECT * FROM Reviews WHERE [GameTitle] = &#039" & RS("Advertisement") & "&#039", strConnection, adOpenStatic, adLockOptimistic, adCmdText<BR><BR><BR>Nice catch-22, huh? I must first have a current record before I can perform the operation that will let me have a current record. If anyone can solve this one (hell, I&#039d be content simply with an EXPLANATION), I&#039d be intensely grateful. Thanks!<BR><BR>--Bill J.<BR>

  2. #2
    Scott S Guest

    Default RE: Opening Recordset requires a current record?

    Does the query itself work? will it return records? try it out in Access (if its an access database) or Query Analyzer (if its an MS SQL 7 DB). Make sure that the query works then lets wrack our brains.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts