Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Color of disable - gray
Message
From
27/12/2000 13:38:45
Walter Meester
HoogkarspelNetherlands
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00455216
Message ID:
00457048
Views:
48
Garret,

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

Walter,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform