Re: Changing serial value

If you want to be able to control the value inserted, you need to use a different data type. If you are just trying to clone a record, exclude the "serial" column from the insert. You cannot specify the value of a serial column. -d At 10:14 AM 8/19/97 +0200, marko kopac wrote: >I don't know how to change a serial value in a table (Informix >database). I need this to copy a record to the same table. First I copy >a record to a temp table. There I try to change the serial value and >then to insert to the original table. This is my idea. Has anybody some >another idea hove to solve this problem? > >Marko > >