Re: PRIMARY KEY

Shavonne Marietta Wijesinghe wrote:
> Hello
> 
> I have created a table
> CREATE TABLE MOD48_00_2007 ( ID text, N_GEN int PRIMARY KEY, FORMSTORE text, COD_NOTAIO text, PA_COGNOME text);
> 
> And i insert the rows via a form in ASP. When the form loads i have a functin that goes and gets the value of the
fieldN_GEN adds 1 to it and shows it to the user.
 
> The problem is when i have 2 users working at the same time.

Check the manuals for "sequences" and "serial type".

--   Richard Huxton  Archonet Ltd