Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Primary Key Value
Message
From
05/03/2004 00:36:19
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00883338
Message ID:
00883386
Views:
6
Nope, it will not guarantee uniqueness. You can get duplicates on a fast system. If you're using VFP 8.0, you can use an AutoInc field. For previous versions, you can use the PK routine on my website. Another alternative is to use a GUID.

>I can't find anywhere that anyone has done this, though I'm certain that you all have.
>
>I have a 2 character TableID.
>I have a datetime value.
>
>I would like to combine those together and somehow covert that into a unique Primary Key value 16 characters. Should I just concatenate the two?
>
>[AA]+ttoc(datetime(), 1)
>
>Will that assure uniqueness across various systems that will not be sharing a table from which they can pull the next available number?
>
>
>Thanks for your comments.
>
>DJ
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Reply
Map
View

Click here to load this message in the networking platform