Subject | Error with stored procedure on TIBOQUERY "Can not SELECT RDB$DB_KEY" |
---|---|
Author | davissammybr |
Post date | 2010-08-04T00:45:11Z |
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.
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.