> Would you have to limit access to the table to a
> single user at a time, at
> least in a multi-user environment? This would be to
> assure that no 2 users
> hitting the table simultaneously get the same
> number, if that's possible, as
> well as other potential problems related to many
> users accessing the table.
There's no guarantee that this would be true, and I
have to allow for simultaneous entries on different
machines more or less at the same time.
I believe the NEXT() function should handle conflicts,
taking out the necessary short term lock on the
AUTONUM column in my dummy table.
--
Larry
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
