Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Views and multiple parameters
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00036190
Message ID:
00036366
Vues:
55
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform