>>>>>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.

I haven't followed very carefully -it's in German - but if it's only about sql - you can use macro substitution for the field name




>
>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