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