Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Flushing data to the tables
Message
From
01/08/2001 15:30:32
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00538379
Message ID:
00538503
Views:
22
>>>SET REFRESH TO has two parameters and second one conrols how offten foxpro refreshes local buffers.
? SET("REFRESH")   && returns the first value that affects BROWSE  refresh
>>>? SET("REFRESH",1)   && returns the second value that affects local buffer refresh
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  && sets 0 as Value1 and 1 as Value2.
>>
>>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
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Reply
Map
View

Click here to load this message in the networking platform