Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>When creating a view in the view designer, what do I do if I want to use a parameter, but not have the user be prompted for it? In other words, if I already have a variable with contains the value I want to use, how do I represent this in the view designer? (Instead of ?Name, which would prompt the user to enter a name, I want it to just use the variable value at runtime.)
>
>Thanks,
Patric,
I'm not sure I totally understand, but if Name has a value, whenever you open or requery the view it will be evaluated by the SQL of the view. Just make sure that the variable Name has a value first and that the variable is available when the view is called.
Renoir
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement