Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multi-Steps error in ADO
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00525714
Message ID:
00525738
Views:
12
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... :)
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform