Focal Point
Passing parameter from one fex file to another fex

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

April 04, 2008, 06:01 AM
souji
Passing parameter from one fex file to another fex
Hi can any one help how to pass a parameter from one fex file to another fex (By using IBIMR and post method).Please give me one example.
Here is my code.Please correct me if iam wrong.
-****TEST.FEX

-DEFAULT &COUNTRY = 'ENGLAND';
TABLE FILE CAR
PRINT
CAR
COUNTRY
SALES
WHERE COUNTRY EQ '&COUNTRY'
END


THIS TEST.FEX WAS CALLED HERE

TABLE FILE CAR
PRINT COMPUTE CTRY_CNT/P2 = IF COUNTRY EQ LAST COUNTRY THEN LAST CTRY_CNT ELSE CTRY_CNT + 1; NOPRINT
COMPUTE CTRY_INP/A100 = ''; AS ''
BY COUNTRY AS ''
-*ON TABLE HOLD AS MYHTML FORMAT HTMTABLE
ON TABLE SET HTMLCSS ON
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
GRID=OFF, SIZE=9, $
TYPE=DATA, COLUMN=COUNTRY, CLASS=ctry_style, $
TYPE=DATA, COLUMN=CTRY_INP, CLASS=chck_style, $
ENDSTYLE
END
-RUN

-HTMLFORM BEGIN


ALL MY SCRIPT HERE









WebFocus 7.1.4 xp html,excel,pdf
April 04, 2008, 06:13 AM
Tom Flynn
Here are the basics:
 
<form name=form1 action='/ibi_apps/WFServlet' method='post' target='_blank'>
<INPUT TYPE='hidden' name='IBIMR_domain'     value='!IBI.AMP.DOMAIN_NAME;'>
<INPUT TYPE='hidden' name='IBIMR_action'     value='MR_RUN_FEX'>
<INPUT TYPE='hidden' name='IBIMR_sub_action' value='MR_STD_REPORT'>
<INPUT TYPE='hidden' name='IBIMR_fex'        value='!IBI.AMP.MR_FEX_NAME;'>
<INPUT TYPE='hidden' name='IBIF_ex'          value='!IBI.AMP.MR_FEX_NAME;'>
<INPUT TYPE='hidden' name='IBIMR_flags'      value=''>
<INPUT TYPE='hidden' name='IBIMR_folder'     value='!IBI.AMP.FOLDER_NAME;'>
<INPUT TYPE='hidden' name='IBIMR_random'     value='!IBI.AMP.RANDOM;'>
<INPUT TYPE='hidden' name='PARAM1'           value='!IBI.AMP.PARAM1;'>
<INPUT TYPE='hidden' name='PARAM2'           value='!IBI.AMP.PARAM2;'>
<INPUT TYPE='hidden' name='PARAM3'           value='!IBI.AMP.PARAM3;'>


Param1 through 3 are your fex-to-fex parameters.

Hope this helps...

Tom


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe