Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Flushing data to the tables
Message
 
 
À
01/08/2001 15:16:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00538379
Message ID:
00538493
Vues:
14
This message has been marked as a message which has helped to the initial question of the thread.
>>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.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform