Re: MDAC Converting Dataset to XML

The generated XML for a "working" instance is as follows:

<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='SEQNO' rs:number='1' rs:write='true'
rs:baseschema='REGVA40' rs:basetable='SALARY_HISTORY'
rs:basecolumn='SEQNO'>
<s:datatype dt:type='number' rs:dbtype='numeric' dt:maxLength='19'
rs:scale='0' rs:precision='3' rs:fixedlength='true'
rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='ROWID' rs:number='2' rs:rowid='true'
rs:baseschema='REGVA40' rs:basetable='SALARY_HISTORY'
rs:basecolumn='ROWID' rs:keycolumn='true' rs:hidden='true'
rs:autoincrement='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='18'
rs:fixedlength='true'/>
</s:AttributeType>
<s:extends type='rs:rowbase'/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row SEQNO='2' ROWID='AAFfXVAAGAAAs+QABB'/>
<z:row SEQNO='3' ROWID='AAFfXVAAGAAAs+cAEU'/>
<z:row SEQNO='4' ROWID='AAFfXVAAGAAAs+cAEV'/>
<z:row SEQNO='5' ROWID='AAFfXVAAGAAAs+QACI'/>
<z:row SEQNO='6' ROWID='AAFfXVAAGAAAs+QACJ'/>
<z:row SEQNO='7' ROWID='AAFfXVAAGAAAs+QACK'/>
<z:row SEQNO='8' ROWID='AAFfXVAAGAAAs+QACL'/>
<z:row SEQNO='9' ROWID='AAFfXVAAGAAAs+kACt'/>
<z:row SEQNO='11' ROWID='AAFfXVAAGAAAs+gACm'/>
<z:row SEQNO='12' ROWID='AAFfXVAAGAAAs+gACn'/>
<z:row SEQNO='13' ROWID='AAFfXVAAGAAAs+gACo'/>
<z:row SEQNO='14' ROWID='AAFfXVAAGAAAs+gACp'/>
<z:row SEQNO='15' ROWID='AAFfXVAAGAAAs+kADR'/>
<z:row SEQNO='16' ROWID='AAFfXVAAGAAAs+oAD2'/>
<z:row SEQNO='17' ROWID='AAFfXVAAGAAAs+oAD3'/>
<z:row SEQNO='18' ROWID='AAFfXVAAGAAAs+oAD4'/>
<z:row SEQNO='19' ROWID='AAFfXVAAGAAAs+oAD5'/>
<z:row SEQNO='20' ROWID='AAFfXVAAGAAAs+oAD6'/>
<z:row SEQNO='21' ROWID='AAFfXVAAGAAAs+oAD7'/>
<z:row SEQNO='22' ROWID='AAFfXVAAGAAAs+UAC9'/>
<z:row SEQNO='23' ROWID='AAFfXVAAGAAAs+wAAs'/>
<z:row SEQNO='24' ROWID='AAFfXVAAGAAAs+QABA'/>
<z:row SEQNO='100' ROWID='AAFfXVAAGAAAs+kACu'/>
</rs:data>
</xml>

For a "broken" instance its:

<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='SEQNO' rs:number='1' rs:writeunknown='true'
rs:baseschema='REGVA40' rs:basetable='SALARY_HISTORY'
rs:basecolumn='SEQNO'>
<s:datatype dt:type='number' rs:dbtype='numeric' dt:maxLength='19'
rs:scale='0' rs:precision='3' rs:fixedlength='true'
rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='ROWID' rs:number='2' rs:rowid='true'
rs:baseschema='REGVA40' rs:basetable='SALARY_HISTORY'
rs:basecolumn='ROWID' rs:keycolumn='true' rs:hidden='true'
rs:autoincrement='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='18'
rs:fixedlength='true'/>
</s:AttributeType>
<s:extends type='rs:rowbase'/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row SEQNO='2' ROWID='AAFfXVAAGAAAs+QABB'/>
<z:row SEQNO='3' ROWID='AAFfXVAAGAAAs+cAEU'/>
<z:row SEQNO='4' ROWID='AAFfXVAAGAAAs+cAEV'/>
<z:row SEQNO='5' ROWID='AAFfXVAAGAAAs+QACI'/>
<z:row SEQNO='6' ROWID='AAFfXVAAGAAAs+QACJ'/>
<z:row SEQNO='7' ROWID='AAFfXVAAGAAAs+QACK'/>
<z:row SEQNO='8' ROWID='AAFfXVAAGAAAs+QACL'/>
<z:row SEQNO='9' ROWID='AAFfXVAAGAAAs+kACt'/>
<z:row SEQNO='11' ROWID='AAFfXVAAGAAAs+gACm'/>
<z:row SEQNO='12' ROWID='AAFfXVAAGAAAs+gACn'/>
<z:row SEQNO='13' ROWID='AAFfXVAAGAAAs+gACo'/>
<z:row SEQNO='14' ROWID='AAFfXVAAGAAAs+gACp'/>
<z:row SEQNO='15' ROWID='AAFfXVAAGAAAs+kADR'/>
<z:row SEQNO='16' ROWID='AAFfXVAAGAAAs+oAD2'/>
<z:row SEQNO='17' ROWID='AAFfXVAAGAAAs+oAD3'/>
<z:row SEQNO='18' ROWID='AAFfXVAAGAAAs+oAD4'/>
<z:row SEQNO='19' ROWID='AAFfXVAAGAAAs+oAD5'/>
<z:row SEQNO='0' ROWID='AAFfXVAAGAAAs+oAD6'/>
<z:row SEQNO='21' ROWID='AAFfXVAAGAAAs+oAD7'/>
<z:row SEQNO='22' ROWID='AAFfXVAAGAAAs+UAC9'/>
<z:row SEQNO='23' ROWID='AAFfXVAAGAAAs+wAAs'/>
<z:row SEQNO='24' ROWID='AAFfXVAAGAAAs+QABA'/>
<z:row SEQNO='0' ROWID='AAFfXVAAGAAAs+kACu'/>
</rs:data>
</xml>

Notice that the 20 and 100 have changed to 0.
The ADO recordset is constant throughout and has the right values.

I believe that the VB equivalent of what I am trying to achieve can be found
in the following article 252767:

http://support.microsoft.com/kb/252767

Many thanks

.