Subject | Re: [firebird-support] Re: Firebird record number |
---|---|
Author | Alexandre Benson Smith |
Post date | 2006-11-29T22:56:11Z |
Ann W. Harrison wrote:
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
> Alexandre Benson Smith wrote:Hi Ann,
>
>
>> 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
>
>
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