On Jan 22, 2007, at 2:15 PM, Carl Karsten wrote:
> I'm not sure I can even code it outside. I am starting to think
> compound keys
> have to be natural keys, as in "input by the user" or some outside
> source, which
> is taken care of by the app or some layer above the data tier, and
> completely
> avoids the code that would be needed to deal with server side.
No, not at all. It could be as simple as Invoice Number + location,
where the invoice number is generated at each site. It could be two
completely random-type numbers, or a sequential value plus a hashed
value.
Aren't most GUID algorithms based on several values whose bits are
then joined? Even though it's stored in a single database column,
conceptually it's a compound key.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
