Reference ADO Recordset Field after CommitTrans

U.N.C.L.E. · November 19th, 2006, 02:26 PM

I seem to getting an error when referencing a field within a recordset after performing a CommitTrans. Following ASP code snippet illustrates this:

Code:

With RS
    DB.BeginTrans

    'Do some database operations here

    If Not ErrorStatus Then
        DB.RollbackTrans
        Exit Function
    End If

    'Do some more db operations here

    DB.CommitTrans

    ' Update field.
    .Fields("myField") = 1                        ' <- Error here
End With

I'm wondering if there are any guidelines on accessing/updating a recordset after a CommitTrans? Also, this same code works in ACCESS VBA module.

woodyz · November 20th, 2006, 12:06 PM

What error are you getting?

Woody Z http://www.learntoprogramnow.com

U.N.C.L.E. · November 20th, 2006, 05:03 PM

ASP Error:

Quote:

quote:error '80020009'
Exception occurred.

I'm wondering if there is a problem with the cursor?

Code snippet that opens recordset:

Code:

    Set db = Server.CreateObject("ADODB.Connection")
    Set rs = Server.CreateObject("ADODB.Recordset")
    db.Open Application("Database_ConnectionString")
    rs.Open SQL, db, adOpenKeyset, adLockOptimistic, adCmdText

woodyz · November 20th, 2006, 06:43 PM

The first this is to verify that you have a record.
Make sure the recordset isn't EOF (or BOF) at the time you are trying to access that field.

Woody Z http://www.learntoprogramnow.com

U.N.C.L.E. · November 20th, 2006, 07:29 PM

Let's assume the code works fine... which it does in an Access Project file. I'm simply trying to port the code to ASP.

woodyz · November 21st, 2006, 03:20 AM

Quote:

quote:Originally posted by U.N.C.L.E.
Let's assume the code works fine... which it does in an Access Project file. I'm simply trying to port the code to ASP.

First of all, the code might work fine, but if there is no data in the table, it will error with the error you are giving.

Assuming that is true (and your code really should check this), what are the field datatypes in your query that creates the recordset. Access will behave differently than ASP with memo fields. Are there any memo fields?

Woody Z http://www.learntoprogramnow.com