Subject Re: [firebird-support] Re: Error : "There is at least one record with same fields values "
Author Martijn Tonies
> > 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:

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
My thoughts:
Database development questions? Check the forum!