Subject Re: [firebird-support] Re: Firebird record number
Author Alexandre Benson Smith
Ann W. Harrison wrote:
> Alexandre Benson Smith wrote:
>
>
>> Firebird has RDB$KEY virtual column that identifies a row uniquely
>> across a database, Google for RDB$KEY and read the Claudios articles
>> about it.
>>
>
> I strongly recommend that you not even consider using RDB$DB_KEY for
> this application. It is a physical record identifier that will change
> if you back up and restore the database. If a record is deleted in
> normal operation, its db_key will be reused.
>
>
> Regards,
>
>
> Ann
>
>

Hi Ann,

As you know it wil even change on diferent transaction.. thats why I
said to him to look on the Claudio's papers.

It's just an option to uniquely identify a row in a very special case.
If used carefuly could be very usefull

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br