>>>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.
I've always used FLUSH in my framework. It does the same thing. I've never had problems.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer