Re: NextNumbers Tables
From: stu <smcgouga_at_nospam.co.uk>
Date: Fri, 14 Feb 2003 11:41:28 -0000
Message-ID: <b2iko0$54c$1$8302bc10_at_news.demon.co.uk>
Date: Fri, 14 Feb 2003 11:41:28 -0000
Message-ID: <b2iko0$54c$1$8302bc10_at_news.demon.co.uk>
"Saul Margolis" <saul_margolis_at_hotmail.com> wrote in message
news:c20aa081.0302140208.4f10eee6_at_posting.google.com...
> This is exactly the way I try to do things, having a surrogate key and
> natural key with a unique index.
>
> Ever tried tracing a transaction manually (as one is sometimes forced
> to do) when you only have a natural key consisting of 10 fields?
yes and Yuck! It would be worth a sequence id just for this. But then again the id does have business meaning: the sequence of transactions!
cheers
Stu
Received on Fri Feb 14 2003 - 12:41:28 CET