Make the query not live (maybe set ReadOnly to true).

IB tries to guess the primary key for live (updateable) queries, if it
cann't find any, it uses the rdb$db_key field, which is valid for normal
table or view queries.

--
Andreas


Am 04.08.2010 02:45, schrieb davissammybr:

>
> Hi all,
>
> I have a stored procedure that when performed on IBExpert no error.
> But when I run it on the component TIBOQuery get the following message:
>
> Can not SELECT RDB$DB_KEY from a stored procedure.
>
> The stored procedure returns a field called IP.
> When I run it generates error as below:
>
> select
> list.ip
> from
> My_StoredProcedure list
>
> If you run this way the error does not happen;
>
> select
> ip
> from
> My_StoredProcedure
>
> What is wrong?
> Thank you.
>

[Non-text portions of this message have been removed]