>>>>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
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]