Connecting Tech Pros Worldwide Forums | Help | Site Map

constraint not declared

Bart V
Guest
 
Posts: n/a
#1: Nov 12 '05
If I try to load a xml schema in a dataset I get this error:
The 'CDSKey1' identity constraint is not declated. An error occurred
at file:///C:/Doc.../CDLib.xsd, (36, 4).

Here is the schema:

<?xml version="1.0" standalone="yes" ?>
<xsd:schema id="CDLib" targetNamespace="CDLib" xmlns=""
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xsd:element name="CDS" msdata:IsDataSet="true"
msdata:Locale="en-GB">
<xsd:complexType>
<xsd:choice maxOccurs="unbounded">
<xsd:element name="CD">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="ID" type="xsd:integer" minOccurs="0" />
<xsd:element name="DevID" type="xsd:integer" minOccurs="0" />
<xsd:element name="PosID" type="xsd:integer" minOccurs="0" />
<xsd:element name="Title" type="xsd:string" minOccurs="0" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="Art">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="ID" type="xsd:integer" minOccurs="0" />
<xsd:element name="CDID" type="xsd:integer" minOccurs="0" />
<xsd:element name="Data" type="xsd:string" minOccurs="0" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:choice>
</xsd:complexType>
<xsd:key name="CDSKey1" msdata:PrimaryKey="true">
<xsd:selector xpath=".//CD" />
<xsd:field xpath="ID" />
</xsd:key>
<xsd:key name="CDSKey2" msdata:PrimaryKey="true">
<xsd:selector xpath=".//Art" />
<xsd:field xpath="ID" />
</xsd:key>
<xsd:keyref name="CDArt" refer="CDSKey1">
<xsd:selector xpath=".//Art" />
<xsd:field xpath="CDID" />
</xsd:keyref>
</xsd:element>
</xsd:schema>

Henry S. Thompson
Guest
 
Posts: n/a
#2: Nov 12 '05

re: constraint not declared


bartverstraete77@hotmail.com (Bart V) writes:
[color=blue]
> If I try to load a xml schema in a dataset I get this error:
> The 'CDSKey1' identity constraint is not declated. An error occurred
> at file:///C:/Doc.../CDLib.xsd, (36, 4).
>
> Here is the schema:
>
> <?xml version="1.0" standalone="yes" ?>
> <xsd:schema id="CDLib" targetNamespace="CDLib" xmlns=""
> xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">[/color]
.. . .[color=blue]
> <xsd:keyref name="CDArt" refer="CDSKey1">
> <xsd:selector xpath=".//Art" />
> <xsd:field xpath="CDID" />
> </xsd:keyref>[/color]


Like all names declared in a schema, CDSKey1 is declared in your
target namespace, so you need a proper qualified name to refer to it.

So add xmlns:cdl="CDLib" to your xsd:schema element, and change your
xsd:keyref to say refer="cdl:CDSKey1"

You will also need to change all your XPaths to use this prefix as
well, or none of them will match.

ht
--
Henry S. Thompson, HCRC Language Technology Group, University of Edinburgh
Half-time member of W3C Team
2 Buccleuch Place, Edinburgh EH8 9LW, SCOTLAND -- (44) 131 650-4440
Fax: (44) 131 650-4587, e-mail: ht@inf.ed.ac.uk
URL: http://www.ltg.ed.ac.uk/~ht/
[mail really from me _always_ has this .sig -- mail without it is forged spam]
Closed Thread