Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View of a View and Requery()
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
View of a View and Requery()
Miscellaneous
Thread ID:
00176940
Message ID:
00176940
Views:
95
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
Next
Reply
Map
View

Click here to load this message in the networking platform