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@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 - 05:41:28 CST