>1) Is it very complicated to create views programatically?
The number of properties (view level and field level) to set is rather larger, but other than that creating the view programatically is not complicated.
Take a look at the program GenDBC that comes with VFP. This program reads your DBC and creates a program file (PRG) to regenerate all views and tables in your database. What I usually do is: (a) Create a basic view with VFP view designer, (b) run GenDBC to get the bulk of the code to generate the view programatically and (c) modify the code manually to add more stuff to the view.
>2) Is it worth the trouble? That is, perhaps there are too many problems involved, or perhaps there are better ways to do it.
I usually have a combination of techniques: simple views with the VFP view designer and complex views programatically.
Hector Correa