Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dev_guy
Starting Member
3 Posts |
 Posted - 2005-02-18 : 11:47:23
|
| Hi there,In the XSD schema I have element name="kategorie" with a 'title' atribute. What I want is to have this atribute in tblImportSpeisekarte table too. For some reason I cannot import this ... please help!- <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sql="urn:schemas-microsoft-com:mapping-schema">- <xsd:annotation>- <xsd:appinfo><sql:relationship name="aaa" parent="lokalkey" parent-key="id" child="lbild" child-key="id" /> <sql:relationship name="bbb" parent="lokalkey" parent-key="id" child="tblImportSpeisekarte" child-key="id" /> </xsd:appinfo></xsd:annotation>- <xsd:element name="lokal" sql:relation="lokalkey">- <xsd:complexType>- <xsd:sequence><xsd:element name="id" type="xsd:string" /> <xsd:element name="lokalname" type="xsd:string" /> - <xsd:element name="bilder" sql:is-constant="1">- <xsd:complexType>- <xsd:sequence>- <xsd:element name="bild" sql:relation="lbild" sql:relationship="aaa" maxOccurs="unbounded">- <xsd:complexType><xsd:attribute name="kategorie" type="xsd:string" /> <xsd:attribute name="name" type="xsd:string" /> <xsd:attribute name="referenz" type="xsd:string" /> </xsd:complexType></xsd:element></xsd:sequence></xsd:complexType></xsd:element>- <xsd:element name="speisekarte" sql:is-constant="1">- <xsd:complexType>- <xsd:sequence>- <xsd:element name="kategorie">- <xsd:complexType>- <xsd:sequence>- <xsd:element name="eintrag" sql:relation="tblImportSpeisekarte" sql:relationship="bbb" maxOccurs="unbounded">- <xsd:complexType><xsd:attribute name="titel" type="xsd:string" /> <xsd:attribute name="text" type="xsd:string" /> <xsd:attribute name="zusatztext" type="xsd:string" /> <xsd:attribute name="preis" type="xsd:string" /> </xsd:complexType></xsd:element></xsd:sequence><xsd:attribute name="title" sql:field="kategorie" sql:relationship="bbb" type="xsd:string" /> </xsd:complexType></xsd:element></xsd:sequence></xsd:complexType></xsd:element></xsd:sequence></xsd:complexType></xsd:element></xsd:schema> |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-02-18 : 21:17:36
|
| Please do not cross-post:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=46110 |
 |
|
|
|
|
|
Bulk Load question ... please help