Hi,

I am passing a multi select parameter to MAINTAIN and getting it as IWC.GetAppCGIValue. The value is stored in a variable in form 'BELLEVILLE', 'BRACEBRIDGE' , 'BRAMPTON'.

How can I use a where clause in For Statement to populate a stack for multi select variable.

For example -

This works
For all next branch_product_details.BRANCH_PRODUCT_DETAILS.ID into BPD where Branch in ('BELLEVILLE' OR 'BRACEBRIDGE' OR 'BRAMPTON');

But this fails -
Declare myBranches / A255 = IWC.GetAppCGIValue("whichBranch");
For all next branch_product_details.BRANCH_PRODUCT_DETAILS.ID into BPD where Branch in (myBranches);

This message has been edited. Last edited by: Kerry,

There are two easy ways of doing this. The first is Maintain and the second is Table.

Maintain:
Assume the selected branches are in BRANCHSTK. You can do this:

Stack clear BPD
Compute i/i3=1;
Repeat BRANCHSTK.FOCCOUNT
Reposition branch_product_details.ID
For all next branch_product_details.ID into BPD(bpd.foccount+1)
Where Branch_product.branch eq branchstk(i).branch;
Compute i = i + 1;
Endrepeat

This loops through the selected branches and each time gets the information from the database.

The second technique passes the selected values as a string to TABLE and uses them in the WHERE clause. Just be careful. If the user can select TOO many values, you run the risk of exceeding the max size of the WHERE clause:

CASE GETDATA
COMPUTE I/2=2;
IF OUTSTK.FOCCOUNT GE 1 THEN BEGIN
COMPUTE VAL/A300=" ' " || OUTSTK(1).CAT || " ' ";
IF OUTSTK.FOCCOUNT GT 1 THEN BEGIN
REPEAT OUTSTK.FOCCOUNT-1;
COMPUTE VAL = VAL || " OR ' " || OUTSTK(I).CAT || " ' ";
COMPUTE I=I+1;
ENDREPEAT
ENDBEGIN
ENDBEGIN
STACK CLEAR MOVSTK
EXEC MULTI1 FROM VAL INTO MOVSTK
ENDCASE

In the Table have:

TABLE FILE MOVIES
PRINT MOVIECODE TITLE BY CATEGORY
WHERE CATEGORY EQ &1
ON TABLE PCHOLD
END

Either one should be good for you.

Mark