> > Others will know better, but I do not think that RDB$DB_KEY is
> > guaranteed static and may not be suitable for use as some form of
> > internal record number.
> >
>
> Just clear something up for me, please. Is RDB$DB_KEY fixed for a given
> record for all time (Oracle style), or randomly variable, depending
> current selection criteria.

RDB$DB_KEY is fixed for the current transaction only.

Here's a read on it:
http://www.cvalde.net/document/mysteriousDbKey.htm
http://www.cvalde.net/document/practical_use_of_the_rdb.htm

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com