The same table cannot be the child table in two nested relations

C

Chuck Cobb

I came across an interesting error yesterday. If you attempt to use ADO.Net
to import an XML file into a DataSet using the DataSet.ReadXML command, you
will receive something similar to the following error:

The same table cannot be the child table in two nested relations.

if there is a field in the table you are importing that has the same name as
the table. For example, I have a table called "Criteria" that has a field
in it called "Criteria". I have exported the contents of the table plus
other tables to an XML file. When I attempt to import the data back into
the dataset, I get an error. Fortunately, the solution to this was easy...
just change the field name to be something else other than the table name.

Microsoft has acknowledged this to be a bug in the following knowledgebase
article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;325696

Chuck
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing XML into ADO.NET Dataset Problem 13
Create XSD Dataset with child table in two nested relations. 1
Cascade fill for tables with FK relationships 1
DataSet nested relations 7
same table cannot be the child table in two nested relations 3
datset with child table in two nested relations 1
Newbie help with relations 2
Two nested relations, but one is to itself 1

Top