Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Force read of a dbf
Message
De
28/01/2016 03:25:38
 
 
À
28/01/2016 03:19:24
Lutz Scheffler (En ligne)
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8.1
Network:
SAMBA Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01630339
Message ID:
01630340
Vues:
88
This message has been marked as a message which has helped to the initial question of the thread.
>How to force read of a DBF?
>
>I have a dbf in concurent use.
>
>This is, a record is changed.
>I try to TABLEUPDATE, this fails due to a field changed. This is intended.
>If I set the field wo the right value TABLEUPDATE still fails. A SELECT will bring right result.
>
>The only way to force right result right now is to close the dbf and let TABLEUPDATE reopen it.
>
>Any idea aside USE IN SELECT(cALIAS) to force the dbf to refresh?

FLOCK() / RLOCK() should do it.

My understanding is, by design, those are the ONLY ways you can be guaranteed to get the currently persisted values.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform