Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing on multiple fields....
Message
From
13/11/2000 07:57:17
 
 
To
13/11/2000 05:36:03
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00440691
Message ID:
00440931
Views:
11
>Concatenated keys are used in almost databases. I just want to know if it will be managed without problemns by VFP database engine.

You're going to run into the same problems that you would in any other database...cascading changes to the fields that make up the PK. You'll also have to check for duplicates everytime. Again, this is not a good choice for a PK. You can use it for a regular key, but PKs should not be based on data entered by the user.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform