P
Per Hornshøj-Schierbeck
I have a Schema describing an XML feed i'm receiving. The problem is, when i
load it i get the above error.
In this schema i have several fields describing an article. Two of these
fields(tables) are called videos and sounds. They both contain a complex
type (table) called Types which contain from 0-unbound number of "type"
elements.
So the case is. Both the sounds and the videos nodes have types/type nodes,
which won't map to my DataSet. I don't think i can get the xml provider to
change the format, but is there any way i can add something to the schema to
allow the "same table" twice?
Thanks in advance
Per
Here is an example to describe the problem:
<xs:element name="sounds">
<xs:complexType>
<xs:sequence>
<xs:element name="sound" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<!-- other fields that isn't causing problems -->
<xs:element name="types" >
<xs:complexType>
<xs:sequence>
<xs:element name="type" type="xs:string"
maxOccurs="unbounded" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="videos">
<xs:complexType>
<xs:sequence>
<xs:element name="video" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<!-- other fields that isn't causing problems -->
<xs:element name="types" >
<xs:complexType>
<xs:sequence>
<xs:element name="type" type="xs:string"
maxOccurs="unbounded" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
load it i get the above error.
In this schema i have several fields describing an article. Two of these
fields(tables) are called videos and sounds. They both contain a complex
type (table) called Types which contain from 0-unbound number of "type"
elements.
So the case is. Both the sounds and the videos nodes have types/type nodes,
which won't map to my DataSet. I don't think i can get the xml provider to
change the format, but is there any way i can add something to the schema to
allow the "same table" twice?
Thanks in advance
Per
Here is an example to describe the problem:
<xs:element name="sounds">
<xs:complexType>
<xs:sequence>
<xs:element name="sound" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<!-- other fields that isn't causing problems -->
<xs:element name="types" >
<xs:complexType>
<xs:sequence>
<xs:element name="type" type="xs:string"
maxOccurs="unbounded" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="videos">
<xs:complexType>
<xs:sequence>
<xs:element name="video" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<!-- other fields that isn't causing problems -->
<xs:element name="types" >
<xs:complexType>
<xs:sequence>
<xs:element name="type" type="xs:string"
maxOccurs="unbounded" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>