Subject: Re: Flatten an XML file
From: "Thomas B. Passin" <tpassin@xxxxxxxxxxxx>
Date: Fri, 1 Mar 2002 15:01:06 -0500
|
[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
| Current Thread |
- Flatten an XML file
- JWM - Fri, 1 Mar 2002 08:09:10 -0500 (EST)
- Andrew Mottershead - Fri, 1 Mar 2002 08:36:21 -0500 (EST)
- JWM - Fri, 1 Mar 2002 13:18:58 -0500 (EST)
- Thomas B. Passin - Fri, 1 Mar 2002 14:58:07 -0500 (EST) <=
|
|