I am chaining Two multiple Select boxes, whose values are populated dynamicaly from a FEX in XML Format.


It is wokring perfect whenever I have in Table File.

For Eg:

TABLE FILE ACTUAL
PRINT
DST.BRANCH_NUMBER
BY BRANCH_NUMBER
WHERE AREA_CODE='&SEL_AREA';
ON TABLE PCHOLD FORMAT XML
END

&SEL_AREA is previous select box value. The Second Select box value changes perfect according to the previous selection.



Where In If i Try Like

SQL DB2 PREPARE SQLOUT FOR
SELECT DISTINCT BRANCH_NUMBER FROM ACTUAL WHERE AREA_CODE='&SEL_AREA';
END

TABLE FILE SQLOUT
PRINT
BRANCH_NUMBER
BY BRANCH_NUMBER
ON TABLE PCHOLD FORMAT XML
END

The values are populated perfectly for the first time. But Chaining doesnt happen according to the Selection.

Any Suggestions ?

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

SQL doesn't support:

 WHERE AREA_CODE = 'value OR value OR value'  

but that is what the first list box would try to pass when you select more than one value.