constraint not declared

[Bart V]

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" msdatarimaryKey="true"> <xsd:selector xpath=".//CD" /> <xsd:field xpath="ID" /> </xsd:key> <xsd:key name="CDSKey2" msdatarimaryKey="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]

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:keyref name="CDArt" refer="CDSKey1"> <xsd:selector xpath=".//Art" /> <xsd:field xpath="CDID" /> </xsd:keyref>

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

 

[Bart V]

. . .

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

Hi I did what u said, but I think I'm doiing something wrong. Now I doesn give me errors it gives me nothing! It dont load the schematic. Here is the altered schematic:
<?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" xmlns:cdl="CDLib"> <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" msdatarimaryKey="true"> <xsd:selector xpath=".//CD" /> <xsd:field xpath="ID" /> </xsd:key> <xsd:key name="CDSKey2" msdatarimaryKey="true"> <xsd:selector xpath=".//Art" /> <xsd:field xpath="ID" /> </xsd:key> <xsd:keyref name="CDArt" refer="cdl:CDSKey1"> <xsd:selector xpath=".//Art" /> <xsd:field xpath="CDID" /> </xsd:keyref> </xsd:element> </xsd:schema>

 

[Bart V]

Oeps my mistake I didn't load in the datagrid, it works now thx for your help.

grtz Bart