>>>>Do you mean to create the whole CA on the fly? I thought an that too, but if he still stuck to views and think it's to tricky.
>>>>To teach how to use CA and create them on the fly? Argh.
>>>
>>>Yes, CursorAdapter has a learning curve - but it's not that bad
>>
>>But it is Gerhards, not mine. :D
>
>
>I know.
>
>
>As to views, the only thing I use macrosubstitution for is in the where clause
>

>select ....
>  where (  &?View_Condition)
>

>
>That doesn't work for columns - not the way I want it to
>
>Maybe a simple select could do. It may be possible to convert that to updatable ( there's a FAQ over here how to make an spt updatable - never tried it though faq#8153

I have eleminiated the last view around 2010.

The question was more about SELECT SQL then VIEW, so I jumped in.

The basic problem is that he likes the query the parameter withoput anything else as USE View.
The WHERE clause has those ugly feature, but as I said above, WHERE runs agains result set, so the parameter is not known to the field list.

Lutz