Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why last record update by view1 not seen in requery view
Message
 
 
À
15/04/2008 15:53:13
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 7 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01310893
Message ID:
01310917
Vues:
25
What's buffering mode for the table?

>
>I have a situation were
>
>(1) two views are opened againest the same table in the same datasession.
>
>(2) View_1 is requery'd and then every record has one column changed using "replace all" and then =tableupdate() is issued. (setting is optomistic Row Buffering)
>
>(3) View_2 is requery'd for basically the same data and all the updated column changes are seen EXCEPT in the last record where the updated column is still blank.
>
>I've tried FLUSH, and other ideas but only get the correct data if I close view_1 and the table before View_2 is requery'd or have view_2 closed and open fresh after the update has occured.
>
>Does anyone know what the issue is between the two views? Is it a Foxpro limitation, etc.
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform