Focal Point
If statement for select box

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

June 06, 2007, 08:25 AM
funsutton
If statement for select box
I am writing a report that so far looks like this:

-DEFAULT &GPA = 'ALL'
-DEFAULT &LEVL = 'ALL'

JOIN SPRIDEN_PIDM IN SPRIDEN TO SGBSTDN_PIDM IN SGBSTDN AS J0
JOIN SGBSTDN_PIDM IN SPRIDEN TO SHRLGPA_PIDM IN SHRLGPA AS J1
JOIN SHRLGPA_PIDM IN SPRIDEN TO SPRADDR_PIDM IN SPRADDR AS J2
JOIN SPRADDR_CNTY_CODE IN SPRIDEN TO STVCNTY_CODE IN STVCNTY AS J3

TABLE FILE SPRIDEN
BY SPRIDEN_LAST_NAME NOPRINT
BY SPRIDEN_FIRST_NAME NOPRINT
BY SPRIDEN_ID
BY SPRIDEN_LAST_NAME
BY SPRIDEN_FIRST_NAME
BY SHRLGPA_GPA
BY SGBSTDN_LEVL_CODE
BY SPRADDR_CNTY_CODE
WHERE SPRIDEN_CHANGE_IND EQ MISSING;
WHERE SGBSTDN_TERM_CODE_EFF EQ '&TERM_CODE';
WHERE SHRLGPA_GPA_TYPE_IND EQ 'O';

-LEVL
-IF &LEVL = 'ALL' THEN GOTO GPA;
WHERE SHRLGPA_LEVL_CODE EQ '&LEVL';
WHERE SGBSTDN_LEVL_CODE EQ '&LEVL';

-GPA
-IF &GPA = 'ALL' THEN GOTO CNTY;
WHERE SHRLGPA_GPA GE '&GPA';

-CNTY
-IF &CNTY_CODE IS NULL THEN GOTO DONE;
WHERE STVCNTY_DESC EQ &CNTY_CODE.(OR(FIND STVCNTY_DESC IN STVCNTY)).CNTY_CODE.;

-DONE
ON TABLE PCHOLD FORMAT EXL2K
END
-EXIT  


Everything was working fine until I added:

-IF &CNTY_CODE IS NULL THEN GOTO DONE;
WHERE STVCNTY_DESC EQ &CNTY_CODE.(OR(FIND STVCNTY_DESC IN STVCNTY)).CNTY_CODE.;
  


Because I am pulling the list for selection, the typical "ALL" that I am using doesn't work. Also, the "is null" doesn't work either. I am getting the following error message:

 0 ERROR AT OR NEAR LINE     33  IN PROCEDURE ADHOCRQ FOCEXEC *
 (FOC260) AN OPERATION IS MISSING AN ARGUMENT
 (FOC009) INCOMPLETE REQUEST STATEMENT
 BYPASSING TO END OF COMMAND
  


Line 33 is the line that begins with "WHERE STVCNTY_DESC EQ"

Does anyone know how to accomplish this?


-Brian

Webfocus v7.6.1 on Windows XP
June 06, 2007, 09:03 AM
Prarie
Is cnty_code Alpha? Have your tried
IF &CNTY_CODE EQ ' ' THEN GOTO DONE;


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
OK, so now I feel stupid. Regardless, that worked well and thanks for answer.


-Brian

Webfocus v7.6.1 on Windows XP
"-IF &CNTY_CODE IS NULL THEN GOTO DONE;"

NULL does not exist in Dialogue Manager, as Prarie stated, use '' (even if the value of &CNTY_CODE is numeric).


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
Oh...don't feel stupid...everyone Smilerneeds another set of eyes sometimes.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003