Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
GUID based on primary key
Message
De
25/08/2002 21:36:23
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00693475
Message ID:
00693507
Vues:
22
>as Jim already said, generating GUIDs out of another value is not possible. But IMO they won't do you too much harm, besides they are consuming space (32 Bytes in a VFP table stored as string and 16 Bytes when stored in SQL Server). In a VFP table you can set a default value function that returns a GUID and in SQL-Server you can use a built in function. So they won't afford any other coding.
>
>BTW: I find GUIDs a very good approach for PKs. They are unique without any ID tables, can be created with a simple function call and can be generated totally offline or in the database.

As more and more applications are talking with other ones, do you think that more database design will go in favor of a GUID approach for their primary key as some of them will travel across the wire to end up in other applications?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform