I would like to use a SQL passthru query that returns nested XML, similar to the one below, and have it populate the appropiate tables in and XMLAdapter.
I am looking for sample code that shows how to do this?
mySQL = "SELECT Customers.CustomerID,Customers.CompanyName," + ;
" Orders.OrderID,Orders.OrderDate," + ;
" Orders.ShipName,Order_details.ProductID," + ;
" Order_details.UnitPrice,Order_details.Quantity" + ;
" FROM Customers" + ;
" Inner Join Orders" + ;
" On Customers.CustomerID = Orders.CustomerID" + ;
" Inner Join [Order Details] Order_details" + ;
" On Orders.OrderID = Order_details.OrderID" + ;
" ORDER BY Customers.CustomerID, Orders.OrderID" + ;
" FOR XML AUTO, ELEMENTS"
Thanks,
Robert - Zxytek