Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Do & Don'ts - NEW
Message
From
31/12/1999 12:14:15
Walter Meester
HoogkarspelNetherlands
 
 
To
31/12/1999 08:24:45
Mike Timpe
Micro Vane, Inc.
Kalamazoo, Michigan, United States
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Re: Do & Don'ts - NEW
Miscellaneous
Thread ID:
00310868
Message ID:
00310939
Views:
24
>Rule 8: All tables have primary keys.
>
>
>
>I agree when one is doing new development or can add the keys to an old system during conversion.
>
>HOWEVER, when you have a Clipper system that has been in use for 17 years and converting the entire system will take 2-3 years, some proper design techniques have to wait. The problem is that some of the Clipper code has to run in parallel with the VFP code and without changing code in 2 systems, primary can only be used sparingly.
>
>I'm posting this as an exception. After 15 years of working on lots of systems written by someone else, I've learned that "Never is a very long time!!!"

So true. I've been maintaining systems with tables without primary keys which work fine. In some cases having no primary key isn't that much of a problem.

For all new systems I develop I always use a PK, for convinient reason.

Walter,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform