Re: autoincremental field ?? Bug

Obnoxio The Clown wrote: > > From: "Mark D. Stock" <mdstock@mydas.freeserve.co.uk> > > > >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? :-) > > You'd better hope he's never your client, then... :-> Ioannis or Jo? Why? Are they bad payers? :-) 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. |/ ////////| +----------------------+-----------------------------------+-----------+