I just might :-)
>>
>>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.
>>
>>:-)
>
>Hi John,
>
>Why don't you grab all 4 parts and make one article mor UT KB?
>:)
>
>Nick
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05