How to use INLIST command

[bebbo]

I have some code similar to below. If I use the inlist command like INLIST(LEFT(Forename,1),"A","B","C&quot, everthing works fine. However if I have a variable for the letters (ie sINLIST = "A,B,C&quot only the first letter is reconnised. All forenames beginning with B and C are ignored. This needs to be a variable as I want the operator to be able to choose the Forenames they want to pick (ie beginning with A,B,D etc...)

Example below only shows Forenames begginning with C. I want C J and B.

sINLIST = "C,J,B"
lcFilter = 'INLIST(LEFT(Forename,1),sINLIST)'

lcFields = SUBSTR(lcFields,2)
lcFilter = SUBSTR(lcFilter,8)

SELECT &lcFields ;
FROM cp_score, cp_member ;
WHERE &lcFilter ;
INTO TABLE test

 

[AChiado]

Hi bebbo,

try

lcFilter = 'INLIST(LEFT(Forename,1),'+sINLIST+')' Andrea C.P.
Italy

 

[ramani]

Hi

INLIST(cWanted,cSearched1,cSearched2...)
where cSearch1, cSearch2 are the expressions to be searched.
A maximum of 24 such expressions can be searched.
These cWanted and other expressions can consist of more than one character.

SO if you look..
? INLIST("CAT","RAT","MAT","CAT&quot.. will return .t.

IN YOUR CASE YOU ARE WANTING TO LOOK FOR ONE CHARACTER. THE BEST COMMAND FOR THIS WILL BE THE $ OPERATOR.
For example..

sINLIST = "CJB"
lcFilter = "LEFT(Forename,1) $ sINLIST"

This will do the requirement.


ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[bebbo]

Thanks, that has worked fine!!!!