Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting a unique key to be used across tables
Message
From
24/11/2004 14:16:25
Charlie Schreiner
Myers and Stauffer Consulting
Topeka, Kansas, United States
 
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00955413
Message ID:
00964454
Views:
12
Hi Kevin,
I now know I mean @@RowCount. In VFP, with native tables, my current GetTheNextKey function doesn't use record locking either. I'm using a cursorAdapter with ConflictCheckType = 3. If there is a conflict writing the new key to the keys table, I know that someone else has updated it since I got the last key, so I must retry. When I run two processes in a loop, both asking for the next key, I actually get better performance than when I use conventional locking.

>Thanks, Venelina (and everyone else)
>
>I got side-tracked on a bunch of different issues, and am now coming back to this one. Venelina and Charlie's responses in particular were interesting, and I'm evaluating every idea right now. Sorry for not responding sooner.
>
>Thanks!
>Kevin
Charlie
Previous
Reply
Map
View

Click here to load this message in the networking platform