Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to use IN clause in VFP
Message
From
24/01/2002 08:20:55
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
24/01/2002 03:12:05
Lakhani Anil
Lakhani Software Solutions
Mumbai, India
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00609547
Message ID:
00609613
Views:
29
>I wants to use parameteric view which will contain lists, like INLIST(Flag,"A","B","D"). Here "A","B","D" will come parametric. It is not working with IN Commands in View

Can you post the SQL statement? The following, I believe, is the correct syntax: SELECT ... WHERE flag in ("A", "B", "D")
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform