GRAB UNIQUE ASCENDING NUMBER FROM DB TABLE
Posted on 2005-05-11
I have a website which produces many quotes. I need to give each quote a unique number. My idea is to have a DB table called quoteNo with a single numeric field in it. When each quote is requested the system will retrieve the current number, add 1 to it, save this as the new number and update it in the table, whislt also saving the value into an ASP variable. This then becomes the current quote number.
I am worried about duplicate numbers being issued though. Is there a way I can accomplish all this whislt the table is "locked out" so i don't get any duplicate quote numbers?
Assume a starting quote number of "1"