>
>We think that we could have problems in the future with views because of reasons such as renaming datafields in tables. Tables will always work, so we prefer tables instead of views.
>
>Greetings,

I've given up the visually designed views - they really are prone to acute amnesia when the underlying table changes. I create them both ways - programmatically and visually, but keep them in a separate .dbc, and keep a routine generated by GenDbc which regenerates this database and its views. So when the underlying tables change, I simply re-run this routine, and they're back. Of course, I do some handwork on this .prg at times, but then run it and let GenDbc re-create it anew. It checks if my handwork is correct, and restores any settings I've omitted.