Error Message (Same table, cannot be the the child of two nested relations)

Brian Kedersha

We created a XML Schema that has nested table relations. We had the
following Warning message come up.

An unhandled exception of the type 'System.ArgumentException' occurred in
system.data.dll

Additional information: The same Table (DOS_Identifiers) cannot be the
child table in two nested relations.

Does anyone know a workaround for this problem? You are suppose to be able
to do this according to the standard from W3C.

HELP!
Thanks in advance

-={Brian Kedersha}=-
bk*******@aol.com
ke*******@cox.net

Nov 12 '05 #1

Subscribe Reply

2854

Christoph Schittko [MVP]

Brian,

It's an acknowledged limitation of the DataSet [0]. The linked posting also
contains a link to another article with a number of work-arounds.

--
HTH
Christoph Schittko [MVP]
Software Architect, .NET Mentor

[0] http://lists.w3.org/Archives/Public/...3Sep/0058.html

"Brian Kedersha" <bk*******@aol.com> wrote in message
news:eN**************@TK2MSFTNGP12.phx.gbl...

We created a XML Schema that has nested table relations. We had the
following Warning message come up.

An unhandled exception of the type 'System.ArgumentException' occurred in
system.data.dll

Additional information: The same Table (DOS_Identifiers) cannot be the
child table in two nested relations.

Does anyone know a workaround for this problem? You are suppose to be able to do this according to the standard from W3C.

HELP!
Thanks in advance

-={Brian Kedersha}=-
bk*******@aol.com
ke*******@cox.net

Nov 12 '05 #2

Similar topics

2581

Error messages that contain table constraint symbols in mysql

by: Tetsuji Ueda | last post by:

Hello, I'm currently porting an application using some other DB to MySQL. The database in question has several tables with foreign key relations. The application is written such that, on table...

MySQL Database

5064

Problem creating DataSet structure from xsd: The same table (...) cannot be the child table in two nested relations.

by: Max | last post by:

Suppose we have an object hierarchy in XSD. For example, let us take Control, Label, TextBox and LinkLabel windows controls. Each control has some properties which are represented as elements....

.NET Framework

4022

Error loading XML into DataSet

by: Kathryn | last post by:

Hello, When I try to load this xml file (see below) into an asp.net dataset using the following code: ds.ReadXml("xmlfilepath\xmlfile.xml", XmlReadMode.Auto) I get the following error: ...

.NET Framework

991

Error: Child Has Multiple Tables

by: Raed Sawalha | last post by:

I have the following code where Build the relation on DataSet Schema I got the error that Child Has Multiple Tables DataTable LoData = new DataTable("LearningOutcomesDT"); DataTable LoDocData...

.NET Framework

1419

XmlDataDocument error with DataSet relationships set

by: Steve | last post by:

I have a dataset. I fill it with two recordsets from SQL queries. Tables are called tblPlanFYSpendingStage, tblSpendingStage.

ASP.NET

885

Error loading XML into asp.net DataSet

by: Kathryn | last post by:

Hello, When I try to load this xml file (see below) into an asp.net dataset using the following code: ds.ReadXml("xmlfilepath\xmlfile.xml", XmlReadMode.Auto) I get the following error: ...

ASP.NET

10086

Why am I getting ForeignKeyConstraint requires child key value error?

by: dbuchanan | last post by:

Hello, Here is the error message; ---------------------------- Exception Message: ForeignKeyConstraint Lkp_tbl040Cmpt_lkp302SensorType requires the child key values (5) to exist in the...

Visual Basic .NET

5446

truncate a table ignoring relations

by: chathura86 | last post by:

hi, i have a table which has child rows in another table. Now i want to truncate this table temporally, because i will re-enter those values in a short time with some changes. cannot use update...

MySQL Database

4086

The table (sequence) cannot be the child table to itself in nestedrelations.

by: mathieu | last post by:

Hi, I am trying to generate xsd from xml, but all tools I have tried so far returns: "The table (sequence) cannot be the child table to itself in nested relations." Is this something you...

.NET Framework

7199

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7273

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

6982

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

7451

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

5572

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

4667

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3150

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1501

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

374

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General