Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Query and Grids: How do I pass a filter variable?
Message
 
À
15/03/1997 12:19:57
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00024394
Message ID:
00024397
Vues:
36
>For example, I want my user to select a state (Florida). The grid (bound to a view) would show only items with Florida. Now when the user selects Nevada, The grid shows only Nevada items.
>
>Sounds simple but I could use any pointers to make this transaction clear. I have success with a query that's hard-coded with "Florida". I am missing how to assign a variable to the query so that it refreshes when the user leaves the prompting box.
>
>p.s.I posted this under Code & Commands but I didn't see it displayed, (after 30 minutes). This is my first call for help on the VFUG.

What about using parameterized view, say

SELECT STATES.STATE FROM STATES ;
WHERE STATES.STATE = ?MyStateValueSelectedFromPromptingBox

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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform