Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
IN clause in Parameterized views
Message
 
To
01/04/1999 18:55:33
Bob Lucas
The WordWare Agency
Alberta, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00204282
Message ID:
00204603
Views:
23
>Another alternative is to use multiple parameters (INLIST(, ?p1, ?p2, ?p3, ?p4, ?p5) etc to some reasonable limit. INLIST has a limit on the size of the string anyway. fill all the parameter with a bogus value and replace the few that you need with real values.

25 is the limit, I believe, I bumped into it once. Also INLIST can't be used with the view designer...but it'll work fine if you use something like Erik Moore's Eview application, available here in the UT files...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Reply
Map
View

Click here to load this message in the networking platform