Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing XML, no parent record id in child table
Message
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Miscellaneous
Thread ID:
01042677
Message ID:
01073632
Views:
21
Alekesy,

Unfortunately, still all .null.

XML structure:
MessageHeader
..PurchaseOrder.AgentPurchaseOrder
....PurchaseOrderHeaderText
......PurchaseOrderLine
..PurchaseOrderNote

Am I addressing the nodes correctly, I am using:
oPOHT=oAdapter.Tables(STRCONV("PurchaseOrderHeaderText",5))
AddXmlField(oPOHT,"parent::node()/dataset:AgentPurchaseOrder",.F.,"POId_1","I",-1,.T.)
AddXmlField(oPOHT,"parent::dataset:PurchaseOrder/dataset:AgentPurchaseOrder",.F.,"POId_2","I",-1,.T.)

oAdapter.SelectionNamespaces=STRCONV("xmlns:myprefix='http://www.namespacedomain/eBusiness'",5)
AddXmlField(oPOHT,"parent::myprefix:PurchaseOrder/myprefix:AgentPurchaseOrder",.F.,"POId_3","I",-1,.T.)
Any other suggestions how to suspend and debug this.

Nick
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform