Re: autoincremental field ?? Bug

Posted in 2000

Mark D. Stock — Thu, 22 Jun 2000 22:05:28 +0100 — source: Informix-list mailing list archive (1991-1998)

Ioannis Demetriades wrote: > > Mark, > > By inserting a record using INSERT INTO office VALUES ( 0, NULL , NULL > .... ) you will not be able to re-use a serial number that has already been > used, even though the record with the next available serial number is not in > your database. Yes, I know that. > You could reuse that serial number only if you did INSERT INTO office > VALUES(656,NULL,....) Yes, I know that too. The point is Jo wants to insert 0 and get 656. I said it can only be done with CREATE TABLE. Were you perhaps talking to Jo? :-) Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+