Many thanks to Bob Barrows for help on my first problem ( see XML to ADO
Recordset and Back Again). Now here's another.
I am trying to create a disconnected, editable recordset from a stored
procedure call in VB6. I've Googled all the relevant code but I can't get
anything
that will let me *edit* the recordset. I always get an error saying the
recordset cannot be edited:
Here are my steps:
1. Use ADO command to get a stored procedure.
2. Convert to an XML do***ent
3. When needed, create a new ADO Recordset, load XML into it
4. Try to insert/update/delete a row. I get this error:
Run-time error '3251':
Current Recordset does not sup****t updating. This may be a limitation
of
the provider, or of the selected locktype.
The recordset comes from a stored procedure, not a table. I fetch it by
way
of an ADO command object. Are these indicators to ADO that the recordset
should be read-only?
I want to be able to edit the local recordset in order to avoid repeated
trips to the database for updated data.
Any help or pointers would be appreciated. Thanks in advance.
Barry
