Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Uniqueness of 'primary_key' is violated.
Message
De
22/09/2004 12:30:33
 
 
À
21/09/2004 19:32:11
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00939529
Message ID:
00945081
Vues:
26
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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform