ROWID

Subject: ROWID > > 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? This assumption is correct for pre version 7 Online. On v7 rowid may change when you update the row. In fact, in v7 you have to specify that you want to use rowid when you create the table. -- David W Chan. London E1, England -- Email: dwc@cix.compulink.co.uk