× 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.



Oh gosh, I wasn't trying to defend a practice. Only to explain the source of it. I apologize if it came out in any other way.

I totally agree with what you say and have keyed nearly all files for years.


On 7/31/2012 8:15 AM, rob@xxxxxxxxx wrote:
I realize you're just trying to come up with an example so I'll throw out
the argument that keying by a person's name is silly (for the reason you
gave).

Let's say I accept that you couldn't change a PF key (many decades ago).
Well, you should have stopped there. Because when you started on about
child files you lost me. It's not like people used Referential Integrity
constraints years ago. It was easy to delete a parent and leave all those
orphans. How did not keying the PF help? Actually it's easier nowadays
to do this. You can set up the foreign key constraints to "cascade". So
if Miss A becomes Miss B it would cascade the key change down through all
the child files. Back in troglodyte times wouldn't you have had to write
a program to cascade that key change down through the children regardless
of whether or not the key was on the PF or in a LF?


Rob Berendt



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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.