>>>SET REFRESH TO has two parameters and second one conrols how offten foxpro refreshes local buffers.
? SET("REFRESH")
>>>? SET("REFRESH",1)
By default Value1=0 - no refresh and Value2=5 - refresh local buffers every 5 second. SET REFRESH TO 0 will set Value1 to 0 and Value2 to 5.
>>
>>Ok, you're right. The value is 5. Just by curiosity, how do we set the 2nd value?
>
SET REFRESH TO 0, 1
>>
>>The SYS(1104) seems to be the solution. I have applied it at the end of the transaction. However, is that a setting that I could apply in the upper level at first and never have to deal with it again or do I have to issue it everytime and want to make sure it flushes the data?
>
>SYS(1104) doesn't change any VFP setting it just flushes buffers at the time when you call it. You have to call it every time you want that be done.
Thanks, very useful