Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement