Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
About parameterized views
Message
De
19/05/1999 09:47:04
 
 
À
19/05/1999 09:39:31
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00220401
Message ID:
00220408
Vues:
25
>I want a parameterized view to first display every records in a page in a pageframe.
>
>Which means that when the form is opened I want to ignore the parameters and I don't want to be prompted to enter values.
>
>Then after that according to the values entered by the user I want to requery to get exactly what's wanted.
>
>Can it be done whith the same parametrized view or do I have to use different views. One without parameters on the form entry and after that others with paramters (depending on the information wanted by the user) ?

If what you are saying is that when the form opens you want the view to be empty
then all you have to do is USE .. NODATA and later put a value to the parameter and requery
if you want the view to have data - then it depends on your parameters for example if your condition is ... cSomeField LIKE ?tcParam .. then you can change the paramater with '%' (SQL equiv. of * in DOS) or if you have a range you can specify values that retrieve the whole range

Personally I would go for the first approach (of no data initially) since the other one, IMHO, goes against the idea of using views to begin with

Arnon
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform