Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Default unique ID values for a field in a remote table ?
Message
De
04/06/1998 15:27:27
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
02/06/1998 12:49:55
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00103696
Message ID:
00104903
Vues:
48
>
>Skipped ? Why ? The NewId would simply lock the table and return the next id as the default value, so why the Ids would be skipped ? I just don't understand...

Well, your bit of code using NewId() may be a part of a transaction which actually never finishes, or there's a problem with the TableUpdate() which the user chooses to solve by giving up and trying later - in the meantime, the last id was already incremented and given to another user, so this value of id was actually never used, and it's a hole. But then, creating a flat-no-holes key is rather tricky and hard to perfect. There's always some unpredictable case left.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform