I created a recordset from the following xml:
<xml xmlns:s='urn:schemas-microsoft-com:xml-data'
xmlns:dt='urn:schemas-microsoft-com:datatypes'
xmlns:rs='urn:schemas-microsoft-com:rowset'
xmlns:z='#RowsetSchema'>
<s:Schema id='RowsetSchema'>
<s:ElementType name='row' content='any' rs:updatable='true'>
<s:AttributeType name='Tran_Type' rs:number='1'>
<s:datatype dt:type='string' dt:maxLength='4' rs:fixedlength='true' rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='Tran_ID' rs:number='1'>
<s:datatype dt:type='string' dt:maxLength='100' rs:fixedlength='true' rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='PO_ID' rs:number='1'>
<s:datatype dt:type='string' dt:maxLength='100' rs:fixedlength='true' rs:maybenull='false'/>
</s:AttributeType>
<s:ElementType name='Item' content='eltOnly' rs:relation='010000000100000000000000'> >
<s:AttributeType name='PO_ID' rs:number='1'>
<s:datatype dt:type='string' dt:maxLength='100' rs:fixedlength='true' rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='Item_ID' rs:number='1'>
<s:datatype dt:type='string' dt:maxLength='100' rs:fixedlength='true' rs:maybenull='false'/>
</s:AttributeType>
</s:ElementType>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row Tran_Type='CA' Tran_ID='984-858-ghf' PO_ID= '233'>
<Item PO_ID='233' Item_ID='34234'/>
<Item PO_ID='233' Item_ID='23423'/>
<Item PO_ID='233' Item_ID='2635523'/>
</z:row>
</rs:data>
</xml>
I need to access the children records. Let me know if this can be done.
<xml xmlns:s='urn:schemas-microsoft-com:xml-data'
xmlns:dt='urn:schemas-microsoft-com:datatypes'
xmlns:rs='urn:schemas-microsoft-com:rowset'
xmlns:z='#RowsetSchema'>
<s:Schema id='RowsetSchema'>
<s:ElementType name='row' content='any' rs:updatable='true'>
<s:AttributeType name='Tran_Type' rs:number='1'>
<s:datatype dt:type='string' dt:maxLength='4' rs:fixedlength='true' rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='Tran_ID' rs:number='1'>
<s:datatype dt:type='string' dt:maxLength='100' rs:fixedlength='true' rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='PO_ID' rs:number='1'>
<s:datatype dt:type='string' dt:maxLength='100' rs:fixedlength='true' rs:maybenull='false'/>
</s:AttributeType>
<s:ElementType name='Item' content='eltOnly' rs:relation='010000000100000000000000'> >
<s:AttributeType name='PO_ID' rs:number='1'>
<s:datatype dt:type='string' dt:maxLength='100' rs:fixedlength='true' rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='Item_ID' rs:number='1'>
<s:datatype dt:type='string' dt:maxLength='100' rs:fixedlength='true' rs:maybenull='false'/>
</s:AttributeType>
</s:ElementType>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row Tran_Type='CA' Tran_ID='984-858-ghf' PO_ID= '233'>
<Item PO_ID='233' Item_ID='34234'/>
<Item PO_ID='233' Item_ID='23423'/>
<Item PO_ID='233' Item_ID='2635523'/>
</z:row>
</rs:data>
</xml>
I need to access the children records. Let me know if this can be done.