From: Milan Babuskov <albis@EUnet.yu> - 2005-11-19 08:41:16
Olivier Mascia wrote:
> You might SELECT RDB$DB_KEY along with your data fields when you select.
> Then you can UPDATE ... WHERE RDB$DB_KEY = ....
> No matter your table has or doesn't have a PK. Each row has a unique
> DB_KEY for the duration of the transaction. And there is no faster
> single direct row access in Interbase/Firebird than through the DB_KEY.
> Going through the PK index is not even as straight as going through the
> DB_KEY for positionned updates.
> Hint: if you ever wondered what the IBPP::DBKey can be used for... ;-)
Is there any chance we could use DBKey without having it in SELECT
statement (I guess your Row class does it)?
Basically, we would like to allow user to do his select the way he
wants, and allow change of values afterwards.