Re: Using rowid in a html anchor / select statement

Brian Martin wrote:
>
> Bill Tierney wrote:
 

> yes. use a key value instead of rowid. it's not a good thing to
> choose for implementation in a state-dependent situation like
> a webserver. things could change before the www user sends the
> updates or whatever. rowid is a fluid value, not a constant
> like a key.

Agreed ... the ONLY time you can use ROWID and be guaranteed of results is during a transaction (before commit) after selecting with the 'FOR UPDATE' option. Otherwise you can end up pointing to a row that has been moved.

Rowid contains the 'physical' location (file/block/offset) info to find a row quickly. After delete, the rowid is meaningless. Before insert, it is meaningless. After update is MAY be meaningless under a variety of conditions.

Hans Received on Mon Sep 30 1996 - 00:00:00 CEST