Hi,

At February 9, 2004, 08:20, DragosH wrote:

> Firebird RC8

> The next sql works just fine:
> select *
> FROM VA_OP Op
> left join split_nr(Trezorerie_NR) sp on 1=1

> but when I try to make a view:

> Invalid token.
> Dynamic SQL Error.
> SQL error code = -104.
> Token unknown - line 38, char 23.
> (.

> Why? It is a bug? Left join with a procedure in view is not
> supported?

It's not a bug. Views don't support Stored Procedures, nor parameters.
Most SPs are designed that they require at least one input parameter,
and you can't pass a parameter into a View from outside a View.
Otherwise a View would be just a simpler selectable SP.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)