Subject Re: [ib-support] Parameters in views
Author Paul Reeves
apatri@... wrote:
>
>
> How to change VALIDA_DELIBERAMENTO = '1' into
> VALIDA_DELIBERAMENTO = :PARAM_NAME;?
>
> Sorry for the unfamiliar names on it.
>

Views are selectable, just like tables. Instead of putting the where
clause in the view why not add the where clause to the select that calls
the view?

select * from myview
where viewcol= :param



Paul

--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further