RE: the idea of unique primary keys to be a solution that hasoutlived its usefulness?

I think it comes down to the business case.  How do you help people make a 
decision on which to use?  It might be record type, it might be date 
driven (for your customers that are snow birds), it might be an order of 
contact.  Baby sitter:  Call this number first, then this, then this, then 
this.

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




"Booth Martin" <Booth@xxxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
11/17/2003 03:54 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
<rpg400-l@xxxxxxxxxxxx>
cc

Subject
RE: the idea of unique primary keys to be a solution that hasoutlived its 
usefulness?






I am curious if i am alone on my thoughts about unique keys.  If there is 
a
very loud silence we will know that unique keys is the answer.  Is there
other ways to have various addresses without using defined record types as
part of the key. 

*vbg*  (I have no delusions abut my weird ideas.) 
 
 
 
---------------------------------------------------------
Booth Martin   http://www.MartinVT.com
Booth@xxxxxxxxxxxx
---------------------------------------------------------
 
-------Original Message-------
 
From: RPG programming on the AS400 / iSeries
Date: 11/17/03 14:12:28
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: the idea of unique primary keys to be a solution that
hasoutlived its usefulness?
 
In this case, I would have a separate file for addresses and use a type to
differentiate them.  We are, in fact, getting ready to develop a new
customer tracking database using a similar model.
 
Donald R. Fisher, III
Project Manager
Roomstore Furniture Company
(804) 784-7600 extension 2124
DFisher@xxxxxxxxxxxxx
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.