Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using INLIST with select statement
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00417794
Message ID:
00417829
Views:
16
Lal,

The INLIST() function doesn't like a vbl like your supplying. For instance,

lcList = ["A","B","C"]

*--This will return 0 records
SELE * FROM CUSTOMERS WHERE INLIST(custno, lcList)

*--Using macro expansion, like this, rtns the results that you're looking for.
SELE * FROM CUSTOMERS WHERE INLIST(custno, &lc_List.)

HTH

-Matt
Previous
Reply
Map
View

Click here to load this message in the networking platform