Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How I can get a value direct from a table not from buffe
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00208583
Message ID:
00208607
Vues:
29
Jose,

The only completely reliable method I've found to do this is to lock the record in question. Something like this:

PC1: Update field

REPLACE Table.Field1 WITH {15/01/1999}

PC2: Get Value
RLOCK()
UNLOCK
? Table.Field1

I don't check whether RLOCK() succeeded in this example. If you absolutely have to have the latest value you'd want to ensure that RLOCK() returned .T.

>I have a network and data are updated from another pc.
>
>I need to get a field value from table direct from disk not from buffer. I put SET REFRESH TO 1 and some times the value I see it's from the buffer an it's different.
>
>Example:
>
>today's date --> {14/01/1999}
>
>PC1: Update field
>
>REPLACE Table.Field1 WITH {15/01/1999}
>
>PC2: Get Value
>
>? Table.Field1
>
>it returns {14/01/1999}
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform