Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
About parameterized views
Message
From
19/05/1999 09:47:04
 
 
To
19/05/1999 09:39:31
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00220401
Message ID:
00220408
Views:
23
>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
Map
View

Click here to load this message in the networking platform