Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using set filter
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00610205
Message ID:
00610206
Views:
20
IN() is an SQL expression
FoxPro has an equivalent INLIST()
SET FILTER TO INLIST(table.NumericField, 1, 2.5)
>Hi!
>I want to know if I can use this expression using set filter:
>
>set filter to table.NumericField in (1, 2.5)
>
>is in() only used in selects?
>
>So far i haven't been able to use that expression.
>In case I can't use that expression with filters , is there something
>similar I can use?
>
>I really want avoid a lots of ANDs and ORs in the expression and
>make easier to set my expressions programmatically.
>
>
>TIA
Previous
Reply
Map
View

Click here to load this message in the networking platform