Are you sure you are populating all of the fields with data? Perhaps there is an attempt to insert a null.

Also, what about constraint violations? Are you trying to insert a value for a foreign key for which no valid value exists.

My guess at this point is that the problem rests with one of these two areas.


A couple of other points... Are you transacting this operation? In other words, are you beginning a transaction, attempting to update the new records, and then based on whether the operation was successful, comitting or rolling back the transaction?

>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... :)