Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only