I have a requirement to find the next available value for a
machine generated primary key in a multi-user environment for a
high volume table. My problem is that I need to find the value
for the key prior to allowing the system user to begin editing a
new record. On a application's screen, the user will be
attempting to do a multi table insert -- the primary key value is
also the foreign key in several other tables.
Because several users will be attempting to do the same type of
inserts simultaneously, I need to be able to prevent other users
from obtaining the same machine generated key.
Has anyone had to do something similar? What was your approach?
Sample code, or helpfull suggestions would be greatly
appreciated.
Thanks in advance.
--
-------------------------------------------------
Stuck in the slow lane on the information superhighway.