Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
GUID as Primary Key
Message
 
À
18/02/2003 12:25:10
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00754530
Message ID:
00754577
Vues:
31
Ken,

The easiest way to handle this situation is to assign each location a code to id the lcoation, then use the standard way fo generating PKs and prepend the generated PK with the Location Code,
* Location code ABB
lcPk = GetNewPK()
* lcPk = "123456"
lcPK = lcLocationCode + lcPK
* Now lcPK = "ABB123456"
This way even after merging it is easy to report by location if needed. You only care that any given generated PK is unique within that location, not within the entire organization.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform