Re: autoincremental field ?? Bug

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... :-> ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com