Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What should the primary key be?
Message
De
03/02/1999 01:45:12
 
 
À
02/02/1999 22:56:44
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00182646
Message ID:
00183314
Vues:
23
Hiya Erik ---

>>.....any system which relies on an incremented number, in VFP, is suspect >IMHO...now in SQL that's a different story.
>
>Would you mind expanding on this?

Sure. VFP has no means of internally managing incremental keys, so it rests on the developer to provide them. Now, the developer must rely on Windows goofy internal buffering and what-not to ensure that sequences remain intact. I have seen time and time again that this can be a problem ---- but not a problem for a server database like SQL or Oracle that totally manage Identity data types (SQL) or sequences (Oracle).
------------------------------------------------
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform