Re: ROWID Question - ADDITION/CORRECTION

The ROWID will be assigned sequentially as long as you do not delete any rows from the table. This also includes not rolling back any transactions that effect this table. A ROLLBACK will have the same effect as a delete is a row has been inserted after the a row that has not been committed, and eventually rolled back. Your are better off with the date time stamp. Chances are you are already storing the date somewhere. -- Ron Delpiere-Smith Consultant, Midnight Computing reds@bigfoot.com Ron Delpiere-Smith <RonDelpiere@earthlink.net> wrote in article <01bbcc6c$b56eeaa0$2f642399@smithp90>... > Tim: > > The ROWID is a combination of the data page number and the slot number > within the page. By adding the rows and never deleting them will preserve > the entry order. > > If you are using fragmentation for this table it will not. > > Informix has take the position that you should not be using ROWID at all. > It was an internal part of the engine and was not intended for end > user/programmer use. > > Why not put a datetime year to fraction in the record. This would provide > some useful data as to when the record was added and maintain the entry > order. > > Just some thoughts > -- > Ron Delpiere-Smith > Consultant, Midnight Computing > > reds@bigfoot.com > > Tim Porreca <tporreca@colburn.com> wrote in article > <328234F5.199F@colburn.com>... > > In 7.2 DS, if I have a table in which I NEVER delete records, will the > > ROWIDs be added sequentially? We have notes tables which need to be > > retrieved in formcode in the order they were entered. > > > > Tim > > >