Multiple-step operation generated errors. Check each status value.

Hi,
I am trying to add a new record to a client side recordset stored in
Session object.
For some reason I keep getting the same error:
"Multiple-step operation generated errors. Check each status value. "
My simple code is
Session("my_fav").AddNew
Session("my_fav")("BPID") = cInt(Request.QueryString("BPID"))
Session("my_fav")("Description") = Request.QueryString("Title")
Session("my_fav").Update
Whereas only the line of Session("my_fav")("BPID") = ... causes this
error.
BPID is an Database integer ID.
When I commented-out this line, the error is not displayed anymore.
I tried use cStr and cInt, but nothing works. I don't think it's a type
issue.

I've read all the posts regarding this error, and nothing helped...

The creation of the recordset (which works great) inside the Session
is:

Set Session("my_fav") = Server.CreateObject("ADODB.RecordSet")
Session("my_fav").LockType = adLockOptimistic
Session("my_fav").CursorType = adOpenStatic
Session("my_fav").CursorLocation = adUseClient
theSQL = "SELECT BPID, Description FROM Table... Where..."
Session("my_fav").Open theSQL , OBJdbConn
Session("my_fav").ActiveConnection = Nothing


Please help.


Thanks a lot!
Ann.

.

Relevant Pages

  • Re: Multiple-step operation generated errors. Check each status value.
    ... Session object. ... from the recordset into a multidimensional array which can be safely ... if not rs.eof then arData = rs.GetRows ... Microsoft MVP -- ASP/ASP.NET ...
    (microsoft.public.data.ado)
  • Multiple-step operation generated errors. Check each status value.
    ... Session object. ... For some reason I keep getting the same error: ... "Multiple-step operation generated errors. ... The creation of the recordset inside the Session ...
    (microsoft.public.vb.database.ado)
  • Re: Jet 3.51 transaction success rate
    ... might cause the new record to become part of that RTS2 recordset. ... Private Sub Command66_Click ... Dim MSX As String ... parent reason has any sub reasons. ...
    (comp.databases.ms-access)
  • Re: Record set not updatable
    ... I've set up an option group that stores the value in a field named ... >recordset becomes un-updatable. ... Is the "Reason for Return" the Primary Key of Table2? ...
    (microsoft.public.access.forms)
  • Re: Data Layer Merits
    ... At the moment we're taking a perfectly good and workable object (an ADO ... recordset) and needlessly reshaping it into something completely different ... for no obvious reason. ...
    (microsoft.public.sqlserver.programming)