Subject | Re: [firebird-support] Re: View and stored procedure data |
---|---|
Author | Pavel Menshchikov |
Post date | 2006-03-22T14:16:28Z |
Hello Luis,
l> I was trying to use a selectable stored procedure in a view, in the
l> join section, and I got the message "Table unknown" for the procedure
l> name (Firebird 1.5), so I was surprised you said that is allowed a
l> stored procedure in a view, because the same sentence in a select
l> query instead of a view works fine.
Probably, your SP has no input parameters, hence you omited round
brackets after the SP name. You may try to call your SP as
YourSPName() when it needs no input parameters.
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com
l> I was trying to use a selectable stored procedure in a view, in the
l> join section, and I got the message "Table unknown" for the procedure
l> name (Firebird 1.5), so I was surprised you said that is allowed a
l> stored procedure in a view, because the same sentence in a select
l> query instead of a view works fine.
Probably, your SP has no input parameters, hence you omited round
brackets after the SP name. You may try to call your SP as
YourSPName() when it needs no input parameters.
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com