[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] database primary keys in XML Schema
Hello everybody, I am developing a XML Schema which should function as an interface to a relational database. I have problems with how to design the primary keys in XML Schema. 1.) When I insert data via XML instance documents the first time, I cannot specify a primary key in my XML instance document because the database automatically creates an auto-increment key. Correct? 2.) What if I, for example, want to insert a city in a geography database (the database has a Country and a City table; 1:n relationship). When inserting a city, how can I specify to which country the city belongs? I needed to know the database primary key for the country, wouldn't I and add this key as an attribute to the city in my instance document? What other solutions do exist? This issue cost me alot of time so far and I would really appreciate any help! Thanks a lot, Markus
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|