Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
IN clause in Parameterized views
Message
From
02/04/1999 12:43:52
Bruce Gilmour
Cal-Mour Consultants
Calgary, Alberta, Canada
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00204282
Message ID:
00204697
Views:
13
>>I want to create a view that contains only certain records (eg- from an order file containing orders 1 through 15 I want to print 3, 6, 7, 9, 12 where the order number is a character field). I figured the easiest way was a parameterized view that contained a clause such as "WHERE ordernumber IN

>That's a known bug...INLIST() will work. (but is not upsizeable, I guess...)

Thanks Bruce. As you state, it has a limited number of parameters ans thus is not feasable. Also please see my reply to Edward. Thanks again for your input.
***************************
Bruce Gilmour

"Two things are infinite, the Universe and human stupidity. And I am not sure about the Universe."
- Albert Einstein
Previous
Reply
Map
View

Click here to load this message in the networking platform