ChildTable Property


XMLTable.ChildTable

Object reference. ChildTable contains an object reference to a child XMLTable object and null (.NULL.) when not populated.

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.

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.

	Copy Code
<?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>

Copy Code

<?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>

Reference

XMLTable Object Properties, Methods, and Events

Other Resources

Properties (Visual FoxPro)

Return Value

Remarks

Example

See Also

Reference

Other Resources