Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What should the primary key be?
Message
De
07/05/1999 14:13:25
 
 
À
05/05/1999 12:14:53
Raymond Humphrys
Michigan Department of Community Health
Bath, Michigan, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00182646
Message ID:
00216161
Vues:
39
Hi Raymond ---

Rick Strahl has some great code to show how this is done at his WestWind website. If you do a search on GUID on the UT in the messages and files, you might some additional info on it there as well.



>Out of curiosity how do you GUID to generate Primary Keys?
>
>thanks
>>Hiya Craig ----
>>
>>I hate @*#^@^&# integers :-)
>>
>>I used to use SYS(3), then went to SYS(2015) and now I'm quite happy generating GUIDs for primary keys.....any system which relies on an incremented number, in VFP, is suspect IMHO...now in SQL that's a different story.
>>
>>>
>>>Actually, Mac went into great detail about why integer is better than character. There is an article on my website that discusses primary keys.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform