PMFJI..

To tag onto this response, in case Mario does not know how to do this, the following code sample will provide an illustration:

If type("oConnection.Errors") = "O" And oConnection.Errors.Count > 0
   For each oError in oConnection.Errors
      ?oError.Number
      ?oError.description
   Next oError
Endif

Good idea on suggesting the errors collection!




>Hi Mario. You may be able to figure out what's going on by looking at the errors collection of the ADO connection. This object will contain information on the errors returned from the various rows in your ADO recordset, during the attempted update.
>
>Each member of the collection (in other words, each error object in the collection) will have a number of properties: Description, Number, NativeError (the provider's returned error code) and several others.
>
>Hope this gives you a good starting point.
>
>
>
>
>-------------------------Original Post---------------------------
>Hi,
>
>I have a disconnected recordset. I set it widh locktype=Batch optimistic,
>Cursor Location= Client. This have a Id column (generated by Sql Server
>2000).
>
>So, i think: 'Ok, ado support offline editing, so i insert a couple of
>records, send to my server, post it, return back the generated id in
>another recordset, and assign it to each new record because i need editing
>it later' And the reality is that last step run "Multiple-step operation
>generated errors. Check each status value..." error. Aagghhh!. I need a
>workaround for it.
>
>I only have 11 days to finish the aplication, and need this done... HELP ME!
>
>Thanks anyway... :)