Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Default unique ID values for a field in a remote table ?
Message
From
04/06/1998 15:27:27
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
02/06/1998 12:49:55
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00103696
Message ID:
00104903
Views:
47
>
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform