Re: ROWID Question - ADDITION/CORRECTION

Ron Delpiere-Smith wrote: > > 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 > > > > > OK, I have a date field already. How can I get formcode to retrieve records on date order? It used to be that date order and ROWID order where the same. Now when you retieve a customer's history, it comes back in random order. Tim