Thomas

I also think it isn't allowed to use a stored procedure in a view, but
I trust Helen, and I tried the Pavel suggestion without success, so I
continue to think I can't use a stored procedure in a view.

Thanks

Luis M. Molinero
--- In firebird-support@yahoogroups.com, "Thomas Steinmaurer" <ts@...>
wrote:

>
> Luis,
>
> > 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).
>
> AFAIR, you can't use a stored procedure in a view definition.
>
>
> Best Regards,
> Thomas Steinmaurer
> LogManager Series - Logging/Auditing Suites supporting
> InterBase, Firebird, Advantage Database, MS SQL Server and
> NexusDB V2
> Upscene Productions
> http://www.upscene.com
>