Hi All,

When using local views, it is not only unnecesary, but probably undesirable to explicitly open the base tables for those views. This gets one into situations where TABLEUPDATE() is being applied to the view and changes are not being saved because the base table is being buffered and never updated.

VFP will open the base tables when the view is USEd. Does this mean you want to access them? NO. Avoid temptation. Stick with the view and apply all deletes, inserts, and updates to the view and then update or revert the view.

If your view is complicated and involves 4 different base tables, how many tables/views are in your DataEnvironment? One. The view.

IF you are new to VFP, keep this tip in mind when designing your application. It'll save you a lot of grief.

:-)