Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Color of disable - gray
Message
 
To
27/12/2000 13:38:45
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00455216
Message ID:
00457072
Views:
38
>>>Forced use of generated PKs
>>I think you'll find that's not just a Fox position: I first read about
>Surrogate Keys in Databased Advisor back in '94 or so.
>Nope, this is not the case.

Oh, so I _didn't_ read about Surrogate Keys in Databased Advisor. Thank you for kindly informing me of this....

>Generated PK's are esspecially usefull in xBase because of the deleted records
>still existing in the table. This only applies to xBase. I don't reject the
>use of generated keys, but I do reject the FORCED use of them. In a lot of
>cases the use of them are doubtfull at the least and there are other
>knowledgable people who reject them when not neccesary. Joe Celko is a great
>refference for this.

http://www.elementkjournals.com/dbm/9708/dbm9781.htm
http://www.teleport.com/~bstonier/devhbook/databasedesign.html
http://www.dbpd.com/vault/9805xtra.htm
http://www.bcarter.com/intsurr1.htm
http://www.datakitti.com/surrogate.htm

Not an xBase article among them. They don't all argue for Surrogates exclusively, but some do....
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform