Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parametized Views
Message
 
 
À
20/09/1998 22:15:17
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00138750
Message ID:
00138899
Vues:
10
yep. Heck, it even works in Access :)

>Does the question mark only work on 5 and above?
>
>Thanks
>
>
>>Views are generally used to get a set of data, for example, all customers in New York. The SQL would include something like WHERE State = "NY". If you put this "NY" constant into the view designer, then you would always get New York customers. You'd never get California customers, so you use a view parameter and your SQL looks like WHERE State = ?vpState. The view parameter is simply a variable. When the query runs, if vpState does not exist, a window will pop up asking for a value. If vpState exists, then it will be used.
Mark McCasland
Midlothian, TX USA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform