I created a View with a parameter. I run it in SQL view and it queries the parameter and gives the correct results; but if I just run the View itself, it does NOT ask for a parameters. Any ideas as to why?
Hello,
Cannot give you a reason why.
You can get around by creating a query with a parameter selecting from the View.
You can also create a filter table and incorporate the field there into the View. Thus updating the filter table record it becomes the parameter for the view.
Example:
Please note that the bottom image is the edit screen in HSQLDB embedded for a View and not simply a Query screen.
I am creating this database for non-techie types so having them go in and change a value in a table directly might be a little dicey…though I supposed I could provide a form for them to do it…I will try the query of the view, but ideally I would like the view to work. The View was created in the first place to to make it easier than using queries. Thanks