RE: serial field functionality

Posted in 1998

Ashby, David — Thu, 6 Aug 1998 08:41:29 +1000 — source: Informix-list mailing list archive (1991-1998)

Bill, No. The minimum the serial number will be reset to is max + 1 of current values. If you try to reset it lower it will default to this value. Regards David Ashby -----Original Message----- From: Bill Weaver [mailto:billw@fscorp.com] Sent: Thursday, 6 August 1998 2:41 To: informix-list@iiug.org Subject: serial field functionality I believe I already know the answer to this but I thought I'd ask the "community at large" to make sure. I have a serial field in a table. That table has several "holes" in the numbers do to things like deletions. If I reset the starting serial value for the table, will it use the values for the "holes" and skip over existing values? There is a long, sad, sordid story behind why I need to do something like this so I won't burden you with the details! -------------------------------------------------------- Name: Bill Weaver E-mail: Bill Weaver <billw@fscorp.com> Date: 08/05/98 Time: 11:40:36 This message was sent by Z-Mail Pro - from NetManage NetManage - delivers Standards Based IntraNet Solutions --------------------------------------------------------