Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Uniqueness of 'primary_key' is violated.
Message
From
22/09/2004 12:30:33
 
 
To
21/09/2004 19:32:11
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00939529
Message ID:
00945081
Views:
29
No strong opinions, I like guids because I am not dependent on a system table to provide information for my key, it is all procedure driven. Nice when you are working with disconnected datasets, such as in a web environment.

>>I think of a customer entered key, much as I would a first name. Good information, but not something you can rely on. Useful for searches, but not a guarentee to find what you are looking for. I use GUIDs for my pk's. Love them.
>
>GUIDs of course solve the problem of creating PKs for computers which are not always connected. I was thinking about the following alternative, but never actually tried it: assign each branch office a different number, and create PKs like: bintoc(branchnum, 2) + bintoc(SerialNumber("TableName"))
>
>... where SerialNumber() gets a sequential number from a special table.
>
>This would use 6 bytes, instead of the 16 used by the GUID. Any opinions?
Carole Shaw
Fred Hutchinson Cancer Research Center

Eagles may soar, but weasels don't get sucked into jet engines.
Previous
Reply
Map
View

Click here to load this message in the networking platform