>>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.
--sb--