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? The ROWID is basically the location of the row in the table space. If a row is deleted, it is possible that the slot (identified by the rowid) could be reused. Obviously, it would then no longer identify the occurance of data that you expected it to. This can be a problem in a multi-user, interactive environment. If you do a query and retain an array of ROWIDs and another user deletes the row identified by that ROWID and subsequently a row is inserted into that same slot, when you fetch the data associated with that rowid, it won't be the same. DCT -- @ David Tomlinson @ @ dtomlnsn@netcom.com @ @ "By day fantastic birds flew through the petrified forest, and @ @ jeweled crocodiles glittered like heraldic salamanders on the @ @ banks of the crystalline river. By night the illuminated man @ @ raced among the trees, his arms like golden cartwheels, his @ @ head like a spectral crown...." @