Henry S. Thompson wrote:[color=blue]
>
bartverstraete77@hotmail.com (Bart V) writes:
>
>[color=green]
>>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=green]
>> <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[/color]
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" 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="cdl:CDSKey1">
<xsd:selector xpath=".//Art" />
<xsd:field xpath="CDID" />
</xsd:keyref>
</xsd:element>
</xsd:schema>
