Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What should the primary key be?
Message
De
08/05/1999 10:32:06
Raymond Humphrys
Michigan Department of Community Health
Bath, Michigan, États-Unis
 
 
À
07/05/1999 14:13:25
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:
00216387
Vues:
28
Sorry to bother you, but I've looked at UT and at Rick's site and I couldn't find any mention of GUID. Would you happen to have any other suggestions?

thanks

>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.
Some days it's not worth chewing through the leather straps ...
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform