Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>I'm having a hell of a time trying to get a local view to update properly in a multi-user environment, in VFP6 or 8. Maybe I'm missing something, but here's the scenario: Two users trying to get the next available part number at the same time using a local view (VSYS) on an unbuffered table called SYSINFO.DBF using the following code.
>
>I'm opening the view at runtime and letting the view open it's source table - For some reason, when I requery the view it knows that it's source table was changed and updates itself accordingly, but the cursor it opened originally does not reflect the change (unless you browse the file - then it snags the new value just fine).
If I understand you right, you have the same view opened on two machines, update one, and want the second to see the changes? That's not going to happen unless the second view is requeried. By definition, views are just a snapshot of the actual data.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement