Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Send parent-child records in single XML
Message
From
01/12/2006 01:21:05
 
 
To
01/12/2006 01:06:05
General information
Forum:
ASP.NET
Category:
Other
Environment versions
Environment:
VB 8.0
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01173991
Message ID:
01174002
Views:
7
Hi Bonnie,

thanks for reply,can you please give me a example?

like this one, this code is VFP
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
>Short answer is yes.
>
>~~Bonnie
>
>
>>Hi toall,
>>
>>Is it possible to send parent-child records in single XML file?
>>
>>thanks,
>>ryan
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform