Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What should the primary key be?
Message
From
08/05/1999 10:32:06
Raymond Humphrys
Michigan Department of Community Health
Bath, Michigan, United States
 
 
To
07/05/1999 14:13:25
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00182646
Message ID:
00216387
Views:
29
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 ...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform