ChildTable Property
Contains an object reference to a child XMLTable object. Read/write.
XMLTable.ChildTable
Return Value
Object reference. ChildTable contains an object reference to a child XMLTable object and null (.NULL.) when not populated.
Remarks
Applies To: XMLTable Class
For nested tables in SQL XML, Visual FoxPro populates the ChildTable property with information about the nested tables involved in the join operation. However, XMLAdapter does not assign the ChildTable property when working with ADO.NET DataSets. For more information about how XMLAdapter treats nested tables for ADO.NET DataSet and SQL XML data sources, see XMLAdapter Class.
Example
The following example illustrates how an XMLAdapter object treats the Orders table as child table for the Customers table and the Order_details table as a child table for the Orders table.
<?xml version="1.0" encoding="utf-8"?>
<SqlXmlAdoData>
<Schema name="Schema1" xmlns="urn:schemas-microsoft-com:xml-data" xmlns:dt="urn:schemas-microsoft-com:datatypes">
<ElementType name="Customers" content="eltOnly" model="closed" order="many">
<element type="Orders" maxOccurs="*"/>
<element type="CustomerID"/>
<element type="CompanyName"/>
</ElementType>
<ElementType name="CustomerID" content="textOnly" model="closed" dt:type="string"/>
<ElementType name="CompanyName" content="textOnly" model="closed" dt:type="string"/>
<ElementType name="Orders" content="eltOnly" model="closed" order="many">
<element type="Order_details" maxOccurs="*"/>
<element type="OrderID"/>
<element type="OrderDate"/>
<element type="ShipName"/>
</ElementType>
<ElementType name="OrderID" content="textOnly" model="closed" dt:type="i4"/>
<ElementType name="OrderDate" content="textOnly" model="closed" dt:type="dateTime"/>
<ElementType name="ShipName" content="textOnly" model="closed" dt:type="string"/>
<ElementType name="Order_details" content="eltOnly" model="closed" order="many">
<element type="ProductID"/>
<element type="UnitPrice"/>
<element type="Quantity"/>
</ElementType>
<ElementType name="ProductID" content="textOnly" model="closed" dt:type="i4"/>
<ElementType name="UnitPrice" content="textOnly" model="closed" dt:type="fixed.14.4"/>
<ElementType name="Quantity" content="textOnly" model="closed" dt:type="i2"/>
</Schema>
<Customers xmlns="x-schema:#Schema1">
<CustomerID>CACTU</CustomerID>
<CompanyName>Cactus Comidas para llevar</CompanyName>
<Orders>
<OrderID>10521</OrderID>
<OrderDate>1997-04-29T00:00:00</OrderDate>
<ShipName>Cactus Comidas para llevar</ShipName>
<Order_details>
<ProductID>35</ProductID>
<UnitPrice>18</UnitPrice>
<Quantity>3</Quantity>
</Order_details>
<Order_details>
<ProductID>41</ProductID>
<UnitPrice>9.65</UnitPrice>
<Quantity>10</Quantity>
</Order_details>
<Order_details>
<ProductID>68</ProductID>
<UnitPrice>12.5</UnitPrice>
<Quantity>6</Quantity>
</Order_details>
</Orders>
</Customers>
</SqlXmlAdoData>
See Also
Reference
XMLTable Object Properties, Methods, and Events