Re: ROWID

Alex McLintock (Alex@arcfan.demon.co.uk) wrote: : Someone quite helpfully pointed me at ROWID since : I was after some sort of Record Number. : I am using various SELECT statements and I want the ROWID : for any table's row to remain the same for the entire lifetime : of my program - even if other records in the table are deleted : or more records added. : Is this a correct assumption? : Alex McLintock To paraphrase David Pimple, "No, No, No, No, hell no" If you ever need to reload the table from a flat-file, or if you ever alter an index to cluster or if you ever do any type of SQL statement like "ALTER TABLE....add row....", the table will be rebuilt and the rowids will change. Instead, use a serial field and create your own unique stamp if you cannot find a combination of columns that makes it unique. Joe "Bubba" Lumbley -- =========================================================================== jlumbley@netcom.com (Joe Lumbley) BancTec Service Corportation 214-450-9896 Dallas, Texas Watch for my _INFORMIX DBA SURVIVAL GUIDE_ in Fall '94 from Prentice Hall! ===========================================================================