General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Using IN operator with view parameter
I am trying to add a view to a database that has the following structure:
vp_cOpenForms = '"COURSESFORM", "STUDENTSFORM"'
SELECT * ;
FROM regman!repolist ;
WHERE Repolist.cformname IN (?vp_cOpenForms) ;
ORDER BY Repolist.cfullname
The view parameter is subject to change. If ?vp_cOpenForms is changed to &vp_cOpenForms the query works from the command line, but is not in a form that can be added to the database. Any ideas on how to make this work or is there another approach that is better suited for this?
Thanks
Steve
Next
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