I am trying to execute different fex based on user selection. However it also give the chart of the first fex and exit out.

Here is my code:

 -DEFAULT &PROC='Security Type'

IF &PROC.QUOTEDSTRING EQ 'Security Type' THEN GOTO PROSTYPE ;
IF &PROC.QUOTEDSTRING EQ 'Fixed or Adjustable' THEN GOTO PROFA ;

-PROSTYPE
EX IBFS:/WFC/Repository/Investment_Analytics/Holdings/By_Security_Type/Portfolio_Holdings_PortfolioType.fex
-RUN
-GOTO THEEND;
-RUN

-PROFA
EX IBFS:/WFC/Repository/Investment_Analytics/Holdings/By_Rate_Type/Portfolio_Holdings_FA.fex
-RUN
-GOTO THEEND;
-RUN

-THEEND
-RUN

END
 

Here is error that I had.
-DEFAULT &PROC='Security Type'
IF 'Security Type' EQ 'Security Type' THEN GOTO PROSTYPE ;
IF 'Security Type' EQ 'Fixed or Adjustable' THEN GOTO PROFA ;
-PROSTYPE
EX Portfolio_Holdings_PortfolioType
-RUN
(FOC1517) UNRECOGNIZED COMMAND IF 'SECURITY TYPE' EQ 'SECURITY TYPE' THEN GOTO PROSTYPE ;
(FOC1517) UNRECOGNIZED COMMAND IF 'SECURITY TYPE' EQ 'FIXED OR ADJUSTABLE' THEN GOTO PROFA ;
0 NUMBER OF RECORDS IN TABLE= 1 LINES= 1
0 NUMBER OF RECORDS IN TABLE= 1 LINES= 1
0 NUMBER OF RECORDS IN TABLE= 15048 LINES= 1
ALPHANUMERIC RECORD NAMED SAVE
0 FIELDNAME ALIAS FORMAT LENGTH
EDATE MYY 6
TOTAL 6
0 NUMBER OF RECORDS IN GRAPH= 102 PLOT POINTS= 3
-GOTO THEEND;
-THEEND
-RUN
END

Any help are greatly appreciate it. Thank you

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

These are Dialogue Manager (DM) commands, and being such require the lines to start with a dash.

quote:

IF &PROC.QUOTEDSTRING EQ 'Security Type' THEN GOTO PROSTYPE ;
IF &PROC.QUOTEDSTRING EQ 'Fixed or Adjustable' THEN GOTO PROFA ;

It may be better practice to use the complete IF...THEN...ELSE syntax which would combine these lines into a single interpretable line.

Just thinking out loud here...

We do something similar and provide the user with a DropDown box that they can select which option to run. The below is an example of one of our working examples where they can select the summary level they want.

 -SET &SUMMARY = &SUMMARIZED.(<Open Only,OPEN>,<All Invoices,ALL>,<By Part Number,BYPART>,<By Document Number,BYDOC>).;
-IF &SUMMARY = 'OPEN' THEN GOTO OPEN
- ELSE IF &SUMMARY = 'ALL' THEN GOTO BYALL
- ELSE IF &SUMMARY = 'BYPART' THEN GOTO BYPART
- ELSE IF &SUMMARY = 'BYDOC' THEN GOTO BYDOC
- ELSE GOTO Label1; 

Thank you Doug and Roger. It works.