writing XML using nested tables...

[Chris Birmele]

I am having difficulties maintaining table relationships when writing
XML files, despite having set the relations property NESTED to TRUE.
I assume therefore that something is wrong with my code. Can anyone
help?

CODE
====
While xmlReader.Read()

'add row to tool table

nRow = ScanResult1.Tool.NewToolRow()
nRow("out_tlname") = xmlReader.GetAttribute("tlName")
ScanResult1.Tool.AddToolRow(nRow)

' add row to toolinstance table

nRow = ScanResult1.ToolInstance.NewRow()
nRow("out_tliPath") = xmlReader.GetAttribute("tlExec")
ScanResult1.ToolInstance.AddToolInstanceRow(mRow)

End While

ScanResult1.WriteXml("c:\temp\test.xml")
Generated XML file: (ToolInstance should be nested...)
================================================== ====
<?xml version="1.0" standalone="yes"?>
<ScanResult xmlns="http://tempuri.org/ScanResult.xsd">
<Tool out_tlname="XXXXX" />
<Tool out_tlname="YYYYY" />
<Tool out_tlname="ZZZZZ" />
<ToolInstance out_tliPath="XX_A" />
<ToolInstance out_tliPath="YY_B" />
<ToolInstance out_tliPath="ZZ_C" />
</ScanResult>
XML Schema:
===========
<xs:element name="Tool" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:complexType>
<xs:sequence>
<xs:element name="ToolInstance">
<xs:complexType>
<xs:sequence>
</xs:sequence>
<xs:attribute name="out_tliPath" type="xs:string"
/>
<xs:attribute name="out_tliStatus"
type="xs:string" />
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="out_tlname" type="xs:string" />
<xs:attribute name="out_tlStatus" type="xs:string" />
</xs:complexType>
</xs:element>