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 (
>dbkey,
>client,
>name)
>as
>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)


Regards,

Ann
www.ibphoenix.com
We have answers.