Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View of a View and Requery()
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
View of a View and Requery()
Divers
Thread ID:
00176940
Message ID:
00176940
Vues:
96
Something I never really thought about until it happened to me. I have a local view [view 1] that is based on a table and another local view [view 2]. I used this new view as the record source of a grid. When I went to issue a requery and a refresh because of a data change, the data in the grid did not change. Because View 1 opens the table and view 2, the requery of view 1 did not automatically cascade the requery down to view 2.

When I realized this, it did make sense because view 2 was already open as a data source for view 1. The solution was to requery view 2 first then view 1.

I submit this only for future reference and searches for others that may benefit from this.
Mark McCasland
Midlothian, TX USA
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform