Re: Changing serial value

Dave Otto wrote: > > 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 > Uhmm, sure you can. If you want Informix to set the serial valuse, insert the column with the serial value set to 0. If you insert a record with any other value (Not Null), you will be able to insert the record, if that value in the serial column is not used in the table, and it is greater that the current value held in the *serial counter* field. (An unsigned long somewhere in that table space.) HTH -Mikey Oh, and a caveat. I tested this with an old copy of SE. So it may or maynot be still true today. (Give it a whirl!) -- #include <std_disclaimer.h> /* Mike Segel (MS385) */ #include <No_Spam.h> #ifdef OFFENDED_BY_CONTENT The author takes no responsibility for this post. Any resemblence to a coherent rational thought is purely coincidence. -The Management. #endif ***************************** Due to AGIS's Refusal to Act Responsibly We are blocking all of their domains at the packet level. This block will exist until AGIS modifies their policies to conform to existing RFCs and net community standards. We encourage all ISPs and domain holders to do the same. *****************************