Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View Designer: Using the IN Clause With A View Parameter
Message
From
07/12/1998 16:27:59
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00164822
Message ID:
00164891
Views:
22
Michael,

This came up over a year ago and I believe that the answer was that it could not be done. I don't remember what may have been recommended to work around the problem, but a search through the files might reveal something.

This was in VFP5 of course, but I haven't heard anyone say that it now works in VFP 6. But who knows!?

Good luck,

Jim N

>Has anyone been able to get the IN clause to work with a view parameter? In the view designer filter if I have ctype IN C,D then it will correcly bring up all records with a ctype of either a C or a D. However, if I put ctype IN ?vp_ctype and run the query and put C,D in the view parameter I only get records with a C in the ctype (or if I put D first I get only records with a D in ctype).
>
>I need to be able use a view parameter to pull records that match a comma delimited list...anyone?
>
>Thanks!
Previous
Reply
Map
View

Click here to load this message in the networking platform