Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
REQUERYing data in a local View
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00186511
Message ID:
00186617
Views:
17
>I have a situation where I need to refresh data in a listbox based on the current state of data within a local view. The view gets data from a table via odbc and I have a set filter to before I requery it first time.
>
>The changes made to the view/cursor do not update the main data table. Trouble is any attemp to refresh the listbox ultimately fires a requery against the source table which is what I don't want. I want to requery / refresh data already in the view so I can filter out some records or drop them back in depending on some filter criteria.
>
>Hope you get the picture.
>
>Any ideas?
>
>Thank you.
>
>
>Mathias

Mathias, what is the RecordSourseType you use in the listbox? Alias?
I did not test that, but may be you can try type 3-SQL Statement, and do SELECT from your view using the same criteria for WHERE as it is in your FILTER for the view.

Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform