Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Behavior of Local View (read-only) when data is updated
Message
From
08/08/2000 15:49:18
 
 
To
08/08/2000 15:22:25
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00402442
Message ID:
00402460
Views:
8
SET REFRESH only applies to browse windows on cursors that other people can update. Since no one else is making changes to a view that you have used, there's really nothing to refresh.
In order to get data changes into the view, you'll have to REQUERY() the view.

>I've created a view for my reports, and so my user can look at records with all the "words" for categories instead of codes.
>
>If someone were to change a value in the underlying data, how would I be sure the change shows up in the view if it's open? Somehow I thought it was connected to SET REFRESH, and if I waited a few seconds the changes would show up.
>
>Are the contents of the view set in stone each time I open it, as if it were an SQL SELECT?
>
>The data won't be changing all that much once the view is open.
Insanity: Doing the same thing over and over and expecting different results.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform