same table cannot be the child table in two nested relations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i get the following error while reading an xml into a dataset
The same table cannot be the child table in two nested relation

is there a solution for it
 
hi
i think has to do with the scheme of your xml.... would you send the
structure of the file you are tring to read
 
The dataSet is doing its best to infer a schema when reading your Xml
document, and it's finding two sets of elements with the same name, and
doesn't know how to handle it.

Experiment if you can with changing the name of one of the sets of elements
and the error will go away.
This is very common when reading Xml that doesn't correspond to the expected
Schema for a DataSet.
--Peter
 
i know it the follwing does not correspod to Xml Schema for a DataSet. is there another approach that i can use to get this workin

<Message><MessageHeader ><Total><Money currency=&quot;CAD&quot;>23433.0</Money></Total></MessageHeader><ItemIn quantity=&quot;1&quot;><ItemDetail><UnitPrice><Money currency=&quot;CAD&quot;>17400.0</Money></UnitPrice><Description >XXX</Description><UnitOfMeasure>EA</UnitOfMeasure><Classification>43222609</Classification></ItemDetail></ItemIn></Message>
 
Back
Top