Re: [GENERAL] data type "serial"

> >
> > So how do you store something in data type serial?
> > I've created the column but everytime I attempt to do an update I get
> > back the error message that I can't store a duplicate key.
> >
> > table_col_seq.last_value = 1
> > increment = 1
> > maxvalue = 2billion something
> >
> > I've tried storing 1,2,some other number in "serial" in the main
> > table to no avail. What is the magic to get this to work. There
> > appears to be no documentation anywhere on the necessary SQL commands
> > to cycle the generator. I've tried the method used for Oracle SQL but
> > that does not work. I'm a bit of a newbie at this.
> >
> > Michael
> > Michael(at)bizsystems(dot)com
>
> You cant insert into a serial as far as I know.
>
> The serial is simply incrimented automatically whenever a new INSERT
> is done on the table.

Hmmm.... that's a real problem when adding it to an existing table.
The values I get back on a select indicate all blanks. I've got
several hundred records in the table at the moment. There must be a
way to update the darn things.

Michael
Michael(at)bizsystems(dot)com