Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View Returns All Records Instead of Subset
Message
 
To
25/04/2001 12:06:47
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00499653
Message ID:
00499656
Views:
21
Have you tried Requery() on the view?

>I have a local view that returns all the records in the source table during program execution instead of the filtered subset I'm expecting. If I browse the view in the project and manually enter the value it works correctly. I've checked the value of the filter expression variable and it appears correct at the time (I believe) that the grid is getting populated from the view. I have traced the variable and the value does not change once set. Where should I be looking when a view does not seem to be filtering although the sent value seems to be correct? Thanks!
>
>Regards, Renoir
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform