Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using IN operator with view parameter
Message
From
01/05/2004 21:43:18
Steven Kleypas
Tarrant County College District
Texas, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Using IN operator with view parameter
Miscellaneous
Thread ID:
00900118
Message ID:
00900118
Views:
49
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
Map
View

Click here to load this message in the networking platform