Persisting recordset to XML and loading back with some invalid data does not raise error. 
Author Message
 Persisting recordset to XML and loading back with some invalid data does not raise error.

Hi There,

We have a framework which uses ADO to retrieve data from an Oracle data
source within MTS objects.  From there, the recordset is persisted to XML
and converted to a inhouse-formatted XML document and sent to the client.
Data manipulation occurs on the client and is sent back to the server-side
MTS object.  This document is converted back to the ADO recordset XML format
and loaded into a Stream.  This stream is fed to a Recordset.Open() method
and then saved back to Oracle.

The problem is that if the client sends back invalid data, no errors occur
when the data is loaded back into the recordset but the recordset does not
save the data either!  The RSXML that is loaded into the stream shows the
invalid data (in the case I noticed it was alphanumeric data in a numeric
field) in the <z:row...> node but when the recordset loads it, it loses all
updated field information.

Is this a known bug with ADO or is this not a bug at all and we're missing

I could probably piece together some sample code to show this problem if
someone is interested.

Thanks for your time

Jeremy Wiebe
Software Developer
Linnet Geomatics

Mon, 19 Jul 2004 05:26:58 GMT
 [ 1 post ] 

 Relevant Pages 

1. Data Shaping - Persist to and load from XML ...

2. How to divide data and schema description in persisted recordset (XML)

3. Loading Xml Data returned from the query loaded into recordset

4. Persist recordset as XML, or cook XML w/ XMLDSO

5. Error persisting XML stream to ADO recordset

6. reading a recordset back from a persisted stream

7. ADO 2.5 persisting recordset as XML

8. persisting recordsets to XML

9. Problem Persisting Filtered Recordset to XML DOM

10. Modifing structure for a persisted ADO - XML recordset

11. RecordSet Persisted XML missing namespace

12. Help: ADO 2.5 XML works, ADTG doesn't with persisted recordsets

Powered by phpBB® Forum Software