Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] SQL Query While Chaining Select
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] SQL Query While Chaining Select
 Login/Join
 
Guru
posted
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,


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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.


WF 8.2.06
Win10 / IE11
AHTML EXL2K PDF
 
Posts: 137 | Registered: October 19, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] SQL Query While Chaining Select

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.