>>Thanks.
>>
>>If I open all my tables at the beginning, and I'm using Private Datasessions in the forms, then I may have problems with that.
>>
>>Kev
>
>
>No, you won't. VFP will do a USE AGAIN in the data session.
One of the problems experienced could be VFP not respecting SET REFRESH when initially opening tables in the datasession 1 and then using private datasessions (PDS). Yes, the tables will be opened faster in the subsequent datasessions, but older data may exist from time to time (e.g. printing reports).
A workaround for this that was documented here (in a previous post) and in the VMP docs is to RLOCK() and release a table in the subsequent PDS when you wanted to be sure you had the most recent data. The RLOCK() forces VFP to update the local cache.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao