RE: autoincremental field ?? Bug

From: "COOPER, Joseph" <Joseph.COOPER@sema.co.uk> > > > -----Original Message----- > > From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] > > >I have tried this so many times that now I'm at about 700. > > > > Why are you trying to do this? Rule number 17 is that your > > keys should have no meaning. So why do you care if > > there's a gap? > >Rule No 16. The client is always right. NO. The client is always the client, he's definitely not always right. >More seriously. There are often situations when your >keys do have meaning for a particular business rule. >Also legacy applications don't always play by the rules :-) Legacy, tough. As to current apps, naughty, naughty, smacky wrist! >I have also tries to create some generic testing for this. >The testing seems to give different results on different >versions of informix. Interesting. Or it would be if I cared. :-) >For example > >CREATE TABLE nona ( test_col SERIAL ); LOL!! ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com