Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Views and multiple parameters
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00036190
Message ID:
00036366
Views:
57
>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
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform