Subject Re: [ib-support] rdb$db_key inside view
Author Ann W. Harrison
At 07:16 PM 9/6/2002 +0200, Danny García Hernández wrote:
>hello list:
>i have created the following view:
>create view view_clients (
>select c.rdb$db_key,client,name from clients
>that is ok!!!
>the view is working fine for all clients table column, but is lying with the
>rdb$db_key value, this appears like symbols.
>i would like what is happen!!!

The dbkey is an eight byte binary number, normally declared as
char(8). The values are not constrained to printable characters.
You might try declaring it as numeric(18,0)


We have answers.