Hello Pavel,

Exactly, my SP has no input parameters, and so I didn't use the
parenthesis (round brackets), but as you suggested I have just tried
the SP name with the parenthesis in the create view sentence, and now
I got the message "Token unknown ("
This is the squema:

create view View_name(Field1,… Fieldn )
as select Field1, … Fieldn
from Table1
join Table2 on …
join SPname() on …

The same sentence in a select works fine (without the parenthesis in
the SP name, because with the parenthesis I got the same error message).
Thanks

Luis Miguel Molinero
Las Rozas - Madrid (Spain)
--- In firebird-support@yahoogroups.com, Pavel Menshchikov
<developer@...> wrote:

>> 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
>