[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: Flatten an XML file
[JWM] > > Thanks for the note and, yes, XML Spy can do this to a point and does it > well...but it will not permit one to add to an Access database if a primary > key is set to not permit duplicate entries...at least that's my experience > with it. > > While I could probably work around this, as I'm doing the work for a local > charitable organization, money, as one might imagine, is sparse. :) > Well, a primary key should never allow duplicate entries, since the definition of a primary key is exactly that it is a unique key for a row. So even if Access could be set to allow it, this capability should not be turned on, as a matter or good database practice. You may have to come up with unique key values yourself, and you can probably do it by using generate-id() on the node that will become a primary key. Cheers, Tom P XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|
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
|