>>Hi Barbara
>>
>>Thanks for responding.
>>
>>>So, if you USE the view, the source tables are opened. If you then close those source tables, but later REQUERY() the view or call TABLEUPDATE(), the tables will be opened again.
>>
>>I was thinking in terms of open tables being corrupted, so I guess after each requery we can safetly close tables?
>
>You could. VFP will open them when it needs them, but opening tables is a relatively slow process. If you're concerned about corruption, instead of closing the tables, you might want to add a FLUSH command after your TABLEUPDATE(), and if you have any control over the server, make sure write caching is turned off.
One more trick that we used back in FPD2.6 was to open the table again, change any record, save it, change back, save, close the table. We did that when we noticed one of the other workstations was stuck (old 100MHz boxes on a bad network, back then). This was the sure way to prevent table corruption and data loss - somehow, Fox was flushing all the buffers from other boxes and saving it fine. Then we were able to reboot the stuck workstation.
If this still works this way, maybe it could be used as a way to prevent corruption... at least in tables (I'm not getting into politics here :).