Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > XML > referential integrity xsd schema file

Thread Tools

referential integrity xsd schema file

Paul Daly
Posts: n/a
I have the following xml file:

and the following xsd file:

I created them using Visual Studio 2005. The designer view of the xsd
shows the proper relation between application updates and database
(one db update version to many app update versions). However, when I
both the xml and xsd file in VS, VS will allow ficticious db version
in the app update's database version element.

I want it so that if there are two database update version numbers...
and 1.1... then only 1.0 or 1.1 should be permitted in the application
update's databaseversion element.

I have tried moving around the <xs:keyref to make sure it was in the
scope. I've also looked into the xpaths to ensure that I'm selecting
correct elements. The problem I have is that although the designer
shows the
proper relationship I'm looking for (as far as I can tell), it doesn't
enforce referential integrety.

What am I doing wrong???

Thanks in advance for your help.

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Foreign keys in MySQL and referential integrity of Database Weasley Java 0 02-02-2010 06:12 AM
A matter of style and referential integrity! earthling XML 0 03-15-2005 09:01 AM
Business Rules & Referential Integrity Paul Johnson ASP .Net 0 11-20-2004 04:41 PM
Database design - enforcing referential integrity on control tables? (sql server and asp 3.0) ASP General 2 08-13-2004 03:34 PM
Mysql referential integrity terry Java 1 09-09-2003 02:04 PM