Hi Sergey,

is it posibble to convert this to VB.Net?

CLOSE DATABASES 
OPEN DATABASE (HOME(2)) + "Northwind\northwind.dbc"

* Create XML
SELECT 0
USE northwind!OrderDetails 
SET ORDER TO ORDERID   && ORDERID
SELECT 0
USE northwind!Orders 
SET RELATION TO OrderID INTO OrderDetails
oXA = CREATEOBJECT("XmlAdapter")
oXA.RespectNesting = .T.
oXA.AddTableSchema("Orders")
oXA.AddTableSchema("OrderDetails")
oXA.ToXML("Orders.xml",,.T.)
***Modify Command Orders.xml 

CLOSE DATABASES ALL

* Load XML
oXA = CREATEOBJECT("XmlAdapter")
oXA.LoadXML("Orders.xml",.T.)
FOR i=1 TO oXA.Tables.Count
	oXA.Tables(i).Tocursor()
ENDFOR
SET

thanks and regards,
ryan.



>See Re: Is it possible to send parent-child records in single XM Message #1126943
>>
>> i have a 2 cursor/tables one is header files and the other one is the details, i want to create a single xml file using my 2 tables.