Re: serial field functionality

In article <35D34F58.1024@bloomberg.net>, kagel@bloomberg.net (Art S. Kagel) wrote: > Bill Weaver wrote: > > > > 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! > > No it will reset itself to max(column)+1 during the first insert. > > I'll return the favor and not bore you with the details, but you can > probably solve you problem if you let us risk accepting the burden. > > Art S. Kagel > You should be able to insert setting the serial number directly to one of the 'unused' values Paul Watson # I don't suffer from WF Software Ltd. # stress, I'm just Tel. (+44) 1436 674729 # a carrier Fax. (+44) 1436 678693 #