Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Primary Key Value
Message
De
05/03/2004 00:36:19
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00883338
Message ID:
00883386
Vues:
7
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform