>Is there a way to programmaticly change structure of a local view?
>

There is no Alter View command in VFP, but you can "parameterize" Views, and also DbSetProp() at runtime. And "Create View" works well at runtime too, for instance after having created a separate, local "views-only" temp database on the fly.

However, in my opinion CursorAdapters (and SPT classes) are more "scalable" when the requirement for instance is to have a Where filters list with many conditions being added and removed dynamically at runtime.


hth
-Stefan