Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View Returns All Records Instead of Subset
Message
De
25/04/2001 12:45:21
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00499653
Message ID:
00499691
Vues:
24
>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)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform