Re: database integrity
From: Gene Wirchenko <genew_at_ucantrade.com.NOTHERE>
Date: Thu, 26 May 2005 09:57:49 -0700
Message-ID: <tqtb91l5qjo8cqt0siu0j186f6d54ou1gr_at_4ax.com>
Date: Thu, 26 May 2005 09:57:49 -0700
Message-ID: <tqtb91l5qjo8cqt0siu0j186f6d54ou1gr_at_4ax.com>
On Mon, 23 May 2005 21:26:10 -0400, Kenneth Downs <knode.wants.this_at_see.sigblock> wrote:
[snip]
>Can we tie this to some examples?
>
>Here is my example. The column "VAT" is added to orders. In down-to-earth
>terms, we are going to add a column to a table. What do you assign as a
>value for existing orders?
Why add anything? Create a different table for "VAT", whether it refers to the vat that the product was made in or something else. The existing data will not have entries for "VAT".
"Vat fiveshes my favourite shtuff! Hic!"
Sincerely,
Gene Wirchenko Received on Thu May 26 2005 - 18:57:49 CEST