Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parameterized View
Message
De
02/09/2002 14:12:13
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, États-Unis
 
 
À
02/09/2002 12:24:12
Steven Dyke
Safran Seats USA
Texas, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00695969
Message ID:
00695990
Vues:
17
My assumtion is you are using local views. The reason for parameter views is to be able to change the where of a view. You can set a varible to filter active or not active. Example
lcActive = "Y"
lcName = "George"

Select * from customer where active = ?lcActive and name = ?lcName
To answere your other view question, a simple way to do this would be as follows,
llSupervisor = .t.

Select * from customer where active = ?lcActive and ;
iif(?llSupervisor,suppername = ?lcName,name = ?lcName)
>The view I have loaded to my form uses parameters to filter by name and if the record has a field set to active. Now I would like to put a function on the form to view a record that has the field set to inactive. How is this done?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform