General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only