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