Hi Helen

I was trying to use a selectable stored procedure in a view, in the
join section, and I got the message "Table unknown" for the procedure
name (Firebird 1.5), so I was surprised you said that is allowed a
stored procedure in a view, because the same sentence in a select
query instead of a view works fine.
Nevertheless, as always, you are right, the solution is to make a
selectable procedure in place of a view.

Thanks

Luis Miguel Molinero Casares
Las Rozas – Madrid (Spain)

--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 03:50 AM 9/03/2006, you wrote:
> >Hi,
> >can i use a stored procedure in a view
> >can i do it
> >
> >i remember that from interbase,
> >i couldn't use stored procedure's data in a view
>
> You can, but it has a lot of undesirable limitations, due to the way
> the standard defines what a view is, including not being allowed to
> process local variables.
>
>
> >if no, will it be in the next versions of firebird 2 or 3
>
> There won't be any change to the way views are defined until/unless
> the standard changes.
>
> Focus on what you want in the output set and turn your thinking
> around to "using a view in a stored procedure". You can't write
> views that contain parameters, but you can write a stored procedure
> with input parameters for any column (or all columns, if you want to!)
>
> ./heLen
>