PROPVARIANT tags in data row of recordset XML



Hi,

The problem is this: I have what I believe to be a persisted ADO
recordset as XML which has datatypes (PROPVARIANTs) in the z:row. I
need to know how to read the XML back into a recordset where the
PROPVARIANT tags will actually be used. The end goal is to use this
recordset to derive actual objects that are persisted, so its possible
the reading that tags should occur AFTER the recordset has been
formed.

Thanks,

Roman

Below is a an example:

- <xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882"
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
- <s:Schema id="RowsetSchema">
- <s:ElementType name="row" content="eltOnly" rs:updatable="true">
- <s:AttributeType name="MSG_SOURCE" rs:number="1"
rs:write="true">
<s:datatype dt:type="string" dt:maxLength="4294967295"
rs:precision="0" rs:long="true" rs:maybenull="false" />
</s:AttributeType>
- <s:AttributeType name="MSG_CODE" rs:number="2"
rs:write="true">
<s:datatype dt:type="string" dt:maxLength="4294967295"
rs:precision="0" rs:long="true" rs:maybenull="false" />
</s:AttributeType>
- <s:AttributeType name="MSG_OBJECT_ID" rs:number="3"
rs:write="true">
<s:datatype dt:type="string" dt:maxLength="4294967295"
rs:precision="0" rs:long="true" rs:maybenull="false" />
</s:AttributeType>
- <s:AttributeType name="MSG_ARG1" rs:number="4"
rs:write="true">
<s:datatype dt:type="string" dt:maxLength="4294967295"
rs:precision="0" rs:long="true" rs:maybenull="false" />
</s:AttributeType>
- <s:AttributeType name="MSG_ARG2" rs:number="5"
rs:write="true">
<s:datatype dt:type="string" dt:maxLength="4294967295"
rs:precision="0" rs:long="true" rs:maybenull="false" />
</s:AttributeType>
- <s:AttributeType name="MSG_ARG3" rs:number="6"
rs:write="true">
<s:datatype dt:type="string" dt:maxLength="4294967295"
rs:precision="0" rs:long="true" rs:maybenull="false" />
</s:AttributeType>
<s:extends type="rs:rowbase" />
</s:ElementType>
</s:Schema>
- <rs:data>
- <rs:insert>
<z:row MSG_SOURCE="" MSG_CODE="" MSG_OBJECT_ID="3948(VT_I4)"
MSG_ARG1="4(VT_I4)" MSG_ARG2="3948(VT_I4)" MSG_ARG3="Test(VT_BSTR)" />
</rs:insert>
</rs:data>
</xml>

.



Relevant Pages

  • Re: How to Programmatically Export as XML & SXL
    ... Unfortunately, I've had precious little to do with XML in Access, so I'm ... you use the ADO Recordset object's Save ... >>Dim rs As ADODB.Recordset ... >>Dim strADTGFile As String ...
    (microsoft.public.access.externaldata)
  • Re: MDAC Converting Dataset to XML
    ... I hadn't realised there was a later version of MDAC than the one we had ... recordset is fine, the code that does this is a mirror of the conversion to ... XML and for completeness I include a copy (albeit ... Can you reproduce the symptom by saving the first piece of xml to a file, ...
    (microsoft.public.data.ado)
  • Re: Database + dll
    ... You can include an XML or ADTG persisted Recordset with the ... XML can be compiled into a DLL as a resource, ... copied to a stream first anyway (not that the recordset would alter the ... It's a simple matter of creating a custom resource type from an XML file at ...
    (microsoft.public.vb.database.ado)
  • Re: XSD to Pascal Objects?
    ... > we're talking about a very niche, specific market. ... > be too simple to justify a high price or else no one would buy it. ... > another, nested recordset. ... > an XML file, it saves all the child recordsets too. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: adodb.recordset.save and back
    ... persisted XML file back into recordset, ... Dim Rs as New ADODB.Recordset ... and when you reconnect it to the database you get the error ...
    (microsoft.public.data.ado)