Re: Primary Keys and Valid_From / Valid_To

From: Thomas Olszewicki <ThomasO_at_cpas.com>
Date: Tue, 24 Jun 2008 13:03:47 -0700 (PDT)
Message-ID: <9a6997dc-46ed-42fa-bb51-19d49fb2ab5e@m73g2000hsh.googlegroups.com>


On Jun 24, 10:34 am, Hans Mayr <mayr1..._at_gmx.de> wrote:
> Hello Thomas,
>
> Thanks for your mail. But you did exactly what I wanted to avoid, you
> argued about a system for articles, prices and currencies. They are
> just an example for the datastructure I have and which can not be
> changed in my context. Just imagine that a certain product is not
> always available and if it is not available there is no price. Thus,
> in the example, I need the valid_to and I need to check if there is a
> valid from, valid to period when I enter something in t_orders. One
> could solve that differently, too. I know. But given a datastructure
> like the one I described above, which I have seen in many places, how
> does one organize that?
>
> Best,
>
> Hans

Hans,
If you cannot change the model nor the structure, you may be left with only one option.
That is a 'trigger option'.

HTH
Thomas Received on Tue Jun 24 2008 - 15:03:47 CDT

Original text of this message