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