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

Click here to load this message in the networking platform