>What is a good way of letting the user enter a few (4-7) view parameters and then requerying the view to those parameters? I am using the view in a custom grid, which I have created to allow indexing on each column via a header click. I have tried using one big view with several parameters but have had problems with a "view definition has changed" message. I have converted all of the view parameter fields to character expressions so an empty character parameter acts like a wild card, but I am having many problems! Does anyone know a good way to do this?
Tony, instead of using a view (where the definition is stored in the DBC) why don't you just use a SQL-Select statement to populate your grid. Then you can modify the parameters with no problem. Just re-run the SELECT statement with the new clauses.
If you are looking for a subset of your view, then you can use the view as the data source of your modified SELECT. This will cut the running time substantially.
HTH
Barbara