Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why last record update by view1 not seen in requery view
Message
De
16/04/2008 09:37:19
 
 
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:
01311071
Vues:
20
>>>What's buffering mode for the table?
>>
>>My global default setting for buffering is record optomistic (views and tables).
>
>Yoyu should tun of buffering for the table when you're using views to update it. Otherwise you'll have to issue tableupdate on the table after tableupdate on the view.

Actually, I only have buffering on the views (buffer mode = 3) and the tables are (buffer mode = 1).

The unusual aspect of this problem is that all records are being updated except the last one after Requirying view_2. I can open the updated table and see the updated last record in it, but view_2 doesn't show the updated last record. After the table is browsed and closed, requirying view_2 will return showing the last record updated.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform