Focal Point
[CLOSED] pass parameter to listbox - filter

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9127053226

July 18, 2012, 11:19 AM
DTIC
[CLOSED] pass parameter to listbox - filter
How can I passing parameter from textbox to listbox. I still not sure how do this.

I have a textbox, a list box
when I enter a string in textbox it will pass that string to a listbox and will filter automatic.

I have this in listbox
TABLE FILE CAR
SUM FST.CAR
BY CAR
// TODO: Add your filters here to replace defaults
ON TABLE PCHOLD FORMAT XML
END

This message has been edited. Last edited by: Kerry,
July 18, 2012, 02:19 PM
dburton
You would need to make your procedure for the listbox include a WHERE statement with a variable. Then you can chain the two controls and at that point you will satisfy the amper variable in your list box control.

Check out these links and try the code I printed below.

Chaining Controls

Applying Conditions to the Chained Controls

  
TABLE FILE CAR
SUM FST.CAR
BY CAR
WHERE COUNTRY EQ &COUNTRY;
ON TABLE PCHOLD FORMAT XML
END


Thanks.


WebFOCUS 7.7.03
Windows Web Server 2008
MS SQL Server 2000
Excel,CSV,PDF,HTML