× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



So you're suggesting creating a view over every child table, and to change
every table reference to point to the new views?


date: Tue, 27 Apr 2021 15:08:22 -0700
from: Peter Dow <petercdow@xxxxxxxxx>
subject: Re: Foreign key constraint with literal?

Hi Justin,

I'm not sure what you mean by "get this to work".

If a part becomes obsolete, I would think that you want to keep it on
the PART_MASTER file, but not have it show up in PROMOTIONS, etc.
Wouldn't a view handle that?

Well, if I focus on the "I need the relationships to
be(PART_MASTER.PART_NO = PROMOTIONS.PART_NO and PART_MASTER.OBSOLETE =
'0')" then you could add a field to PROMOTIONS that is defined like the
OBSOLETE flag in PART_MASTER, but always has a constant value of '0'.?
Then the relationship would be

PART_MASTER.PART_NO = PROMOTIONS.PART_NO and PART_MASTER.OBSOLETE =
PROMOTIIONS.OBSOLETE

Of course that's a lot of tables that need to be changed, but perhaps
it's a simpler change than adding a trigger program.

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx>




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.