On 13 Jul 2005 at 0:39, buppcpp@... wrote:

>> Simple answer: you can't and you don't need. There is other syntax
>> to use RDB$DB_KEY as Helen already told you.
>
>So do you mean that the only way to update a record by db_key, from
>within an application (not Stored Procedure) is by way of parameters?

I mean that tables without primary keys must die! It is well known
mantra in RU.DELPHI.DB: "table must have a primary key".
The only way to update record by RDB$DB_KEY without hacks is SELECT
FOR UPDATE + UPDATE WHERE CURRENT OF.

>You can't format it as hex or a char representation?

You can format DB_KEY as whatever you wish. You can't do reverse
conversion: interprete anything as RDB$DB_KEY. BTW, do you know that
size of RDB$DB_KEY is not fixed?
--
SY, Dimitry Sibiryakov.