>>>>When you have a local view, is it a must that the VFP table(s) on which the view is based have to be open all the time?
>>>
>>>Yes.
>>>
>>
>>I believe the answer is NO, base tables can be closed.
>>
>
>Hi Aleksey,
>
>Would VFP re-open base tables automatically when REQUERY() or TABLEUPDATE() is issued for such view?

I would expect them to be reopened. Those functions simply execute SQL statements and SQL statements open referenced tables automatically.

Thanks,
Aleksey.