Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View Returns All Records Instead of Subset
Message
From
25/04/2001 12:45:21
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:
00499691
Views:
27
>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

Doug,

That was it. I took this app over from someone else and assumed he had built the requery logic into the app base classes. As you sometimes said - a lifetime ago it seems - at Kaiser, 'When you assume, you make..." Glad to see you're still kicking around some code...

Thanks, Renoir
(renoir@belsouth.net; jay.johengen@ncmail.net)
Previous
Reply
Map
View

Click here to load this message in the networking platform