Daniel L. Miller wrote:

>Ivan Prenosil wrote:
>
>
>
>>>>Views need something "solid" to look onto :). If you need such
>>>>functionality, create a simple selectable SP instead of view. Something
>>>>like this:
>>>>
>>>>
>>>>
>>>>
>>>In my case I do need an View that does contain all columns from an
>>>table (but restricting the Rows). This table does have lots of
>>>columns, an SP would be very inconvenient to write.
>>>
>>>
>>>
>>>
>>If the SP returns only one value, it can be included in the select list
>>of the view as subquery. E.g.
>>
>>Create View V (id, a,b) As
>> SELECT id, a, (select x from MySP(tab.id)) FROM tab;
>>
>>
>>
>>
>Doesn't that result in
>
>Create View V (id, a,b) As
> SELECT id, a, (select x from MySP(tab.id)) FROM tab;
>
>Dynamic SQL Error SQL error code = -206 Column unknown X At line ?,
>column ??.
>
>

Answer to my own question - the column "x" needs to be the name of the
procedure result parameter.

--
Daniel