Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Composite primary keys
Message
From
01/12/2004 10:50:20
 
 
To
01/12/2004 10:43:22
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00966059
Message ID:
00966107
Views:
10
>On the other hand, relationships between tables will be a lot simpler if you store the Primary key in a single field.

I may be biased, but I like working with composite keys. In your example, how do you established the foreign keys once you have merged two fields into one ?
But I am very happy with your BINTOC solution, which according to my test indeed preserves the order.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform