Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Refresh HTML page when *.fex changes

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Refresh HTML page when *.fex changes
 Login/Join
 
Platinum Member
posted
I created a single *.fex. I then created 3 different *.html pages that use that one *.fex. Each *.html page only exposes 1 of 3 different search parameters. All is right with the world. Smiler

I then went back to my original *.fex and made an edit by adding a new field to be displayed. I was "hoping" that all 3 *.html pages would pick up the *.fex change because I did an "Insert / Existing Procedure".

It appears that the *.html page has a request tag where it looks like there's a copy and paste of the text from the *.fex at the time it was inserted.

It seems like I can fix the issue by going in to each specific HTML and right click on my report and re-import the *.fex again - but that kind of defeats the purpose of my master plan to only want to update a single *.fex and have the updates trickle down to the other *.html pages too. 6 months from now I'll have no idea how many different *.html pages may have the same report on it.

I've spent a fair amount of time searching Focal Point - and reading the Designing a User Interface for a Web Application With the HTML Composer - but I'm not seeing anything.

Is there a "smart" way to have the *.html page reference a *.fex - but not have a copy of it at the time it was inserted? Kind of like an include perhaps? Did I build my *.html pages incorrectly? We are building our *.fex and *.html pages under the Content section (if that matters).

Thanks,

Jeremy



My *.fex has a new column:
MOVIES.MOVINFO.RELDATE

But - here's what's showing up in my *.html page (no RELDATE)


< !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
"http://www.w3.org/TR/html4/strict.dtd">




<script type=text/javascript>//confidential_id=IBI_OptionsScript
var szHtmlAlias="/ibi_apps/ibi_html";var szRunTimeHtmlAlias="runTimeHtmlAlias";var cgipath="cgipath";var ibirls="ibirls3";var rltdyncalendar="rltdyncalendar";var map="ibimap";var olap="olap";var olappanebase="olappanebase";var olapdrill="olapdrill";var ibiOptions = new Array(cgipath,ibirls);var nlsScript="/javaassist/nls.js";var nlsVarsScript="/javaassist/nlsvars.js";var glbScript="/javaassist/ibi/html/js/ibigbl.js";var replacePart="";
var scriptTemplate='<script src="'+replacePart+'" type="text/javascript"><\/SCRIPT>';if(typeof(szRunTimeHtmlAlias) === 'string' && szRunTimeHtmlAlias.indexOf('/') == 0)szHtmlAlias=szRunTimeHtmlAlias;document.write(scriptTemplate.replace(replacePart, szHtmlAlias + nlsScript));document.write(scriptTemplate.replace(replacePart, szHtmlAlias + nlsVarsScript));document.write(scriptTemplate.replace(replacePart, szHtmlAlias + glbScript));

<script type=text/javascript>//confidential_id=IBI_ibigblloadCss
if(typeof ibigblloadCss === 'function'){ibigblloadCss(null);addIntlTranslatedJS("composertrans.js");}else {alert("JavaScript alias '/ibi_apps/ibi_html' is not valid");window.location("about:blank");}
HtmlPage
<script for=window type=text/javascript eventname="onload">window.onload = function() { window_onload(); }

<script>//confidential_id=clientEventHandlersJS


//Begin function window_onload
function window_onload() {

UpdateData();

// TODO: Add your event handler code here
//add onInitialUpdate() function to make changes before initial run of the reports
}
//End function window_onload


<iframe style="Z-INDEX: 1; POSITION: absolute; WIDTH: 1270px; HEIGHT: 540px; TOP: 130px; LEFT: 10px" id=report1 class="IBIfield IBI_Report-iFrame IBI_rounded_m" tabIndex=1 elementtype="2" requests_list="0" autoExecute="false" name="report1">
<script type="text/xml" nextelementuniquenumber="3">le controltype="7" parametercreatedinreslay="0" type="default" desc="H2O_CATEGORY" name="H2O_CATEGORY" default=" " textvarname="" accept="0" select="0" create="1">< ![CDATA[-* Set up blank deafults
-DEFAULT &H2O_TITLE = '';
-DEFAULT &H2O_CATEGORY = '';
-DEFAULT &H2O_RATING = '';


-* If Blank - change to _FOC_NULL - webFOCUS param that will drop out the whole line if _FOC_NULL exists (secrelty this means the where clause goes BYE-BYE
-SET &H2O_TITLE = IF TRUNCATE(&H2O_TITLE) EQ '' THEN '_FOC_NULL' ELSE &H2O_TITLE ;
-SET &H2O_CATEGORY = IF TRUNCATE(&H2O_CATEGORY) EQ '' THEN '_FOC_NULL' ELSE &H2O_CATEGORY;
-SET &H2O_RATING = IF TRUNCATE(&H2O_RATING) EQ '' THEN '_FOC_NULL' ELSE &H2O_RATING;


-* Massage user input. If Blank - do nothing to speed processing. If Not Blank - Left Justify, Upper Case, Trim trailing blanks and add the % for the LIKE SQL statement.
-IF &H2O_TITLE EQ '_FOC_NULL' THEN GOTO :ENDTITLE ELSE CONTINUE;
-SET &H2O_TITLE = LJUST(&H2O_TITLE.LENGTH,&H2O_TITLE,'A&H2O_TITLE.LENGTH');
-SET &H2O_TITLE = UPCASE(&H2O_TITLE.LENGTH,&H2O_TITLE,'A&H2O_TITLE.LENGTH');
-SET &H2O_TITLE = TRUNCATE(&H2O_TITLE);
-SET &H2O_TITLE = '%' || &H2O_TITLE || '%';
-:ENDTITLE;

-* Massage user input. If Blank - do nothing to speed processing. If Not Blank - Left Justify, Upper Case, Trim trailing blanks and add the % for the LIKE SQL statement.
-IF &H2O_CATEGORY EQ '_FOC_NULL' THEN GOTO :ENDCATEG ELSE CONTINUE;
-SET &H2O_CATEGORY = LJUST(&H2O_CATEGORY.LENGTH,&H2O_CATEGORY,'A&H2O_CATEGORY.LENGTH');
-SET &H2O_CATEGORY = UPCASE(&H2O_CATEGORY.LENGTH,&H2O_CATEGORY,'A&H2O_CATEGORY.LENGTH');
-SET &H2O_CATEGORY = TRUNCATE(&H2O_CATEGORY);
-SET &H2O_CATEGORY = '%' || &H2O_CATEGORY || '%';
-:ENDCATEG;

-* Massage user input. If Blank - do nothing to speed processing. If Not Blank - Left Justify, Upper Case, Trim trailing blanks and add the % for the LIKE SQL statement.
-IF &H2O_RATING EQ '_FOC_NULL' THEN GOTO :ENDRATING ELSE CONTINUE;
-SET &H2O_RATING = LJUST(&H2O_RATING.LENGTH,&H2O_RATING,'A&H2O_RATING.LENGTH');
-SET &H2O_RATING = UPCASE(&H2O_RATING.LENGTH,&H2O_RATING,'A&H2O_RATING.LENGTH');
-SET &H2O_RATING = TRUNCATE(&H2O_RATING);
-:ENDRATING;



TABLE FILE MOVIES
PRINT
MOVIES.MOVINFO.TITLE
MOVIES.MOVINFO.CATEGORY
MOVIES.MOVINFO.RATING
MOVIES.MOVINFO.DIRECTOR
WHERE MOVIES.MOVINFO.TITLE LIKE &H2O_TITLE.QUOTEDSTRING;
WHERE MOVIES.MOVINFO.CATEGORY LIKE &H2O_CATEGORY.QUOTEDSTRING;
WHERE MOVIES.MOVINFO.RATING EQ &H2O_RATING.QUOTEDSTRING;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END]]>


<script type=text/javascript>//confidential_id=IBI_loader
if(typeof doBeforeLoad === 'function'){doBeforeLoad();}function AdjustChildrenPosition(){
}


< !-- cc frynk -->

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


webFOCUS 8207.15
WindowsServer 2019
 
Posts: 120 | Location: Minnesota | Registered: August 26, 2013Report This Post
Platinum Member
posted Hide Post
I should have known not to copy and past raw HTML.

I'll try that again - but this time I changed the < to [ and > to ].


[!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
"http://www.w3.org/TR/html4/strict.dtd"]
[HTML][HEAD]
[META id=RLT_STANDARDS_MODE_META content=IE=9 http-equiv=X-UA-Compatible]
[META name=mycharsetmeta content="text/html; charset=ISO-8859-1" http-equiv=Content-Type]
[META name=Generation content="Created in release 8005, Generation 3"]
[SCRIPT type=text/javascript]//confidential_id=IBI_OptionsScript
var szHtmlAlias="/ibi_apps/ibi_html";var szRunTimeHtmlAlias="runTimeHtmlAlias";var cgipath="cgipath";var ibirls="ibirls3";var rltdyncalendar="rltdyncalendar";var map="ibimap";var olap="olap";var olappanebase="olappanebase";var olapdrill="olapdrill";var ibiOptions = new Array(cgipath,ibirls);var nlsScript="/javaassist/nls.js";var nlsVarsScript="/javaassist/nlsvars.js";var glbScript="/javaassist/ibi/html/js/ibigbl.js";var replacePart="[replace]";
var scriptTemplate='[SCRIPT src="'+replacePart+'" type="text/javascript"][\/SCRIPT]';if(typeof(szRunTimeHtmlAlias) === 'string' && szRunTimeHtmlAlias.indexOf('/') == 0)szHtmlAlias=szRunTimeHtmlAlias;document.write(scriptTemplate.replace(replacePart, szHtmlAlias + nlsScript));document.write(scriptTemplate.replace(replacePart, szHtmlAlias + nlsVarsScript));document.write(scriptTemplate.replace(replacePart, szHtmlAlias + glbScript));[/SCRIPT]

[SCRIPT type=text/javascript]//confidential_id=IBI_ibigblloadCss
if(typeof ibigblloadCss === 'function'){ibigblloadCss(null);addIntlTranslatedJS("composertrans.js");}else {alert("JavaScript alias '/ibi_apps/ibi_html' is not valid");window.location("about:blank");}[/SCRIPT]
[TITLE]HtmlPage[/TITLE][LINK id=ITEM2 rel=stylesheet type=text/css UserSuppliedFullPath="1" rtFileName="cgipathsub/ibi_html/javaassist/ibi/html/composer/themes/nonBindows/IBI-Themes/default_theme.css"][LINK id=IBI_THEME_CSS rel=stylesheet type=text/css UserSuppliedFullPath="1" desc="Information Builders" rtFileName="cgipathsub/ibi_html/javaassist/ibi/html/composer/themes/nonBindows/IBI-Themes/ibi.css"]
[SCRIPT for=window type=text/javascript eventname="onload"]window.onload = function() { window_onload(); }[/SCRIPT]

[SCRIPT]//confidential_id=clientEventHandlersJS


//Begin function window_onload
function window_onload() {

UpdateData();

// TODO: Add your event handler code here
//add onInitialUpdate() function to make changes before initial run of the reports
}
//End function window_onload
[/SCRIPT]
[/HEAD]
[BODY style="OVERFLOW: auto" class=IBI_PageBg edaconnectionrequired="true" elementtype="21" thumbnailscale="4" maptype="0" nextelementuniquenumber="3"][IFRAME style="Z-INDEX: 1; POSITION: absolute; WIDTH: 1270px; HEIGHT: 540px; TOP: 130px; LEFT: 10px" id=report1 class="IBIfield IBI_Report-iFrame IBI_rounded_m" tabIndex=1 elementtype="2" requests_list="0" autoExecute="false" name="report1"][/IFRAME]
[FORM style="Z-INDEX: 2; POSITION: absolute; WIDTH: 477px; HEIGHT: 82px; TOP: 20px; LEFT: 10px" id=form1 class="IBIfield IBI_ReportControlPanel IBI_rounded_m" onsubmit="OnExecute(this);return false;" method=post requests_list="0" form_dist_between_desc_and_input="10" form_hor_dist_between_controls="10" vert_dist_between_controls="10" form_number_of_columns="4" form_number_of_visible_rows="4" form_prompt_location="1" form_type="1" default_slider_type="4" form_newline_chain="1" fexlist_list="report1" tempwidth="477" tempheight="82" name="form1"][LABEL style="Z-INDEX: 5; POSITION: absolute; WIDTH: 54px; DISPLAY: none; HEIGHT: 13px; TOP: 5px; CURSOR: default; LEFT: 5px" id=label1 class="IBIfield IBI_ReportControlLabel" tabIndex=4 for=edit1 name="edit1"]H2O_TITLE[/LABEL][INPUT style="Z-INDEX: 6; POSITION: absolute; OVERFLOW-Y: visible; WIDTH: 140px; DISPLAY: none; OVERFLOW: visible; TOP: 28px; LEFT: 5px" id=edit1 class="IBIfield IBI_ReportControlTarget IBI_rounded_s IBI_TextBox" tabIndex=5 value=" " hspace=0 type=text persistentuniqueid="compUid_1" requiredfield="1" boundtovariable="1" defaultlocation="0,0,15,120" defaultselection="1" name="edit1"][LABEL style="Z-INDEX: 7; POSITION: absolute; WIDTH: 81px; DISPLAY: none; HEIGHT: 13px; TOP: 5px; CURSOR: default; LEFT: 155px" id=label2 class="IBIfield IBI_ReportControlLabel" tabIndex=6 for=edit2 name="edit2"]H2O_CATEGORY[/LABEL][INPUT style="Z-INDEX: 8; POSITION: absolute; OVERFLOW-Y: visible; WIDTH: 140px; DISPLAY: none; OVERFLOW: visible; TOP: 28px; LEFT: 155px" id=edit2 class="IBIfield IBI_ReportControlTarget IBI_rounded_s IBI_TextBox" tabIndex=7 value=" " hspace=0 type=text persistentuniqueid="compUid_2" requiredfield="1" boundtovariable="1" defaultlocation="0,0,15,120" defaultselection="1" name="edit2"][LABEL style="Z-INDEX: 9; POSITION: absolute; WIDTH: 65px; HEIGHT: 13px; TOP: 5px; CURSOR: default; LEFT: 305px" id=label3 class="IBIfield IBI_ReportControlLabel" tabIndex=8 for=edit3 name="edit3"]H2O_RATING[/LABEL][INPUT style="Z-INDEX: 10; POSITION: absolute; OVERFLOW-Y: visible; WIDTH: 140px; OVERFLOW: visible; TOP: 28px; LEFT: 305px" id=edit3 class="IBIfield IBI_ReportControlTarget IBI_rounded_s IBI_TextBox" tabIndex=9 value=" " hspace=0 type=text persistentuniqueid="compUid_3" requiredfield="1" boundtovariable="1" defaultlocation="0,0,15,120" name="edit3"][INPUT style="Z-INDEX: 3; POSITION: absolute; WIDTH: 38px; HEIGHT: 22px; TOP: 55px; LEFT: 5px" id=form1Submit class="IBIfield IBI_button IBI_btn-run" tabIndex=2 value=" " type=submit name="submit1"][INPUT style="Z-INDEX: 4; POSITION: absolute; WIDTH: 38px; HEIGHT: 22px; TOP: 55px; LEFT: 48px" id=form1Reset class="IBIfield IBI_button IBI_btn-reset" tabIndex=3 value=" " type=reset name="reset1"][/FORM][INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=layoutinfo type=hidden resourcectrlids="ITEM2;IBI_THEME_CSS" name="inputhidden1"][INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibiapp_app value=H2OSales type=hidden ismre="1" name="ibiapp_app"][INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibif_ex value=/WFC/Repository/H2OSales/Customer_Sales/WhereTestMovieRating.htm type=hidden name="ibif_ex"][xml id=focus_xmlelement][script type="text/xml" nextelementuniquenumber="3"][rootxmlnode focoption="_FOC_NULL"][variables][variable controltype="7" parametercreatedinreslay="0" type="default" desc="H2O_TITLE" name="H2O_TITLE" default=" " textvarname="" accept="0" select="0" create="1"][link linktype="default" from="compUid_1"][condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0"][data_info datatype="0" modifiedrequest="0" displayfield="H2O_TITLE" datafield="H2O_TITLE" datasource="movies.mas" ibif_ex="movies" selectedvalue=" " operation="" slider_range_from="" slider_range_to="" previewvalue=" " sourcetype="typeMaster"][static_values][static value=" " display=" " selected="1" noinput="0"][/static][/static_values][/data_info][/condition][/link][requestid id="0"][/requestid][/variable][variab
le controltype="7" parametercreatedinreslay="0" type="default" desc="H2O_CATEGORY" name="H2O_CATEGORY" default=" " textvarname="" accept="0" select="0" create="1"][link linktype="default" from="compUid_2"][condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0"][data_info datatype="0" modifiedrequest="0" displayfield="H2O_CATEGORY" datafield="H2O_CATEGORY" datasource="movies.mas" ibif_ex="movies" selectedvalue=" " operation="" slider_range_from="" slider_range_to="" previewvalue=" " sourcetype="typeMaster"][static_values][static value=" " display=" " selected="1" noinput="0"][/static][/static_values][/data_info][/condition][/link][requestid id="0"][/requestid][/variable][variable controltype="7" parametercreatedinreslay="0" type="default" desc="H2O_RATING" name="H2O_RATING" default=" " textvarname="" accept="0" select="0" create="1"][link linktype="default" from="compUid_3"][condition default="1" name="Default" whattodowithcontrol="4" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0"][data_info datatype="0" modifiedrequest="0" displayfield="H2O_RATING" datafield="H2O_RATING" datasource="movies.mas" ibif_ex="movies" selectedvalue=" " operation="" slider_range_from="" slider_range_to="" previewvalue=" " sourcetype="typeMaster"][static_values][static value=" " display=" " selected="1" noinput="0"][/static][/static_values][/data_info][/condition][/link][requestid id="0"][/requestid][/variable][/variables][input_controls][input_control bindcontrolid="compUid_1" elementtype="7" name="edit1" id="edit1" multiple="0" onetimepopulated="1"][link linktype="default" persistentuniqueid="compUid_1"][condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0"][data_info datatype="0" modifiedrequest="0" datasource="movies.mas" ibif_ex="movies" addalloption="0" sourcetype="typeMaster" cacheruntimedata="0" accept="0" operation="NONE"][static_values][static value=" " display="" selected="0" noinput="0"][/static][/static_values][/data_info][/condition][/link][/input_control][input_control bindcontrolid="compUid_2" elementtype="7" name="edit2" id="edit2" multiple="0" onetimepopulated="1"][link linktype="default" persistentuniqueid="compUid_2"][condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0"][data_info datatype="0" modifiedrequest="0" datasource="movies.mas" ibif_ex="movies" addalloption="0" sourcetype="typeMaster" cacheruntimedata="0" accept="0" operation="NONE"][static_values][static value=" " display="" selected="0" noinput="0"][/static][/static_values][/data_info][/condition][/link][/input_control][input_control bindcontrolid="compUid_3" elementtype="7" name="edit3" id="edit3" multiple="0" onetimepopulated="1"][link linktype="default"][condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0"][data_info datatype="0" modifiedrequest="0" datasource="movies.mas" ibif_ex="movies" addalloption="0" sourcetype="typeMaster" cacheruntimedata="0" accept="0" operation="NONE"][static_values][static value=" " display="" selected="0" noinput="0"][/static][/static_values][/data_info][/condition][/link][/input_control][/input_controls][requests nextrequestsid="0"][request requestid="0" targetname="report1" ibif_ex="report1" targettype="iframe" sourcetype="typeAdhocfex" activereport="0" compoundreport="0" reportcolumns="" reportrealcolumns="" ibiapp_app=""][![CDATA[-* Set up blank deafults
-DEFAULT &H2O_TITLE = '';
-DEFAULT &H2O_CATEGORY = '';
-DEFAULT &H2O_RATING = '';


-* If Blank - change to _FOC_NULL - webFOCUS param that will drop out the whole line if _FOC_NULL exists (secrelty this means the where clause goes BYE-BYE
-SET &H2O_TITLE = IF TRUNCATE(&H2O_TITLE) EQ '' THEN '_FOC_NULL' ELSE &H2O_TITLE ;
-SET &H2O_CATEGORY = IF TRUNCATE(&H2O_CATEGORY) EQ '' THEN '_FOC_NULL' ELSE &H2O_CATEGORY;
-SET &H2O_RATING = IF TRUNCATE(&H2O_RATING) EQ '' THEN '_FOC_NULL' ELSE &H2O_RATING;


-* Massage user input. If Blank - do nothing to speed processing. If Not Blank - Left Justify, Upper Case, Trim trailing blanks and add the % for the LIKE SQL statement.
-IF &H2O_TITLE EQ '_FOC_NULL' THEN GOTO :ENDTITLE ELSE CONTINUE;
-SET &H2O_TITLE = LJUST(&H2O_TITLE.LENGTH,&H2O_TITLE,'A&H2O_TITLE.LENGTH');
-SET &H2O_TITLE = UPCASE(&H2O_TITLE.LENGTH,&H2O_TITLE,'A&H2O_TITLE.LENGTH');
-SET &H2O_TITLE = TRUNCATE(&H2O_TITLE);
-SET &H2O_TITLE = '%' || &H2O_TITLE || '%';
-:ENDTITLE;

-* Massage user input. If Blank - do nothing to speed processing. If Not Blank - Left Justify, Upper Case, Trim trailing blanks and add the % for the LIKE SQL statement.
-IF &H2O_CATEGORY EQ '_FOC_NULL' THEN GOTO :ENDCATEG ELSE CONTINUE;
-SET &H2O_CATEGORY = LJUST(&H2O_CATEGORY.LENGTH,&H2O_CATEGORY,'A&H2O_CATEGORY.LENGTH');
-SET &H2O_CATEGORY = UPCASE(&H2O_CATEGORY.LENGTH,&H2O_CATEGORY,'A&H2O_CATEGORY.LENGTH');
-SET &H2O_CATEGORY = TRUNCATE(&H2O_CATEGORY);
-SET &H2O_CATEGORY = '%' || &H2O_CATEGORY || '%';
-:ENDCATEG;

-* Massage user input. If Blank - do nothing to speed processing. If Not Blank - Left Justify, Upper Case, Trim trailing blanks and add the % for the LIKE SQL statement.
-IF &H2O_RATING EQ '_FOC_NULL' THEN GOTO :ENDRATING ELSE CONTINUE;
-SET &H2O_RATING = LJUST(&H2O_RATING.LENGTH,&H2O_RATING,'A&H2O_RATING.LENGTH');
-SET &H2O_RATING = UPCASE(&H2O_RATING.LENGTH,&H2O_RATING,'A&H2O_RATING.LENGTH');
-SET &H2O_RATING = TRUNCATE(&H2O_RATING);
-:ENDRATING;



TABLE FILE MOVIES
PRINT
MOVIES.MOVINFO.TITLE
MOVIES.MOVINFO.CATEGORY
MOVIES.MOVINFO.RATING
MOVIES.MOVINFO.DIRECTOR
WHERE MOVIES.MOVINFO.TITLE LIKE &H2O_TITLE.QUOTEDSTRING;
WHERE MOVIES.MOVINFO.CATEGORY LIKE &H2O_CATEGORY.QUOTEDSTRING;
WHERE MOVIES.MOVINFO.RATING EQ &H2O_RATING.QUOTEDSTRING;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END]]][/request][/requests][other_bound_objects][/other_bound_objects][/rootxmlnode][/script]
[/xml][/BODY]
[SCRIPT type=text/javascript]//confidential_id=IBI_loader
if(typeof doBeforeLoad === 'function'){doBeforeLoad();}function AdjustChildrenPosition(){
}
[/SCRIPT]
[/HTML]
[!-- cc frynk --]


webFOCUS 8207.15
WindowsServer 2019
 
Posts: 120 | Location: Minnesota | Registered: August 26, 2013Report This Post
Master
posted Hide Post
hi,

I'd choose "reference existing procedure" instead of insert.

This would not put the FEX code in the HTML. ( which is what you want. )

If you change the fex afterward ( add a &option ) you just have to 'reassign' the run button to the fex to refresh the parameters.

It will suffice to just open the hyperlink properties and click 'ok' to 'reassign'.

Good luck,
Dave


_____________________
WF: 8.0.0.9 > going 8.2.0.5
 
Posts: 668 | Location: Veghel, The Netherlands | Registered: February 16, 2010Report This Post
Master
posted Hide Post
Oh and I do like this concept:

quote:
-* Massage user input


Cool


_____________________
WF: 8.0.0.9 > going 8.2.0.5
 
Posts: 668 | Location: Veghel, The Netherlands | Registered: February 16, 2010Report This Post
Expert
posted Hide Post
Ditto to Dave's use "reference existing procedure"... Always.
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Platinum Member
posted Hide Post
Dave/Doug - thanks for the info.

I kept going to the Insert / Import Existing. Now I see the "Reference Existing Procedure" in the right click menu. Good stuff to know.

Thanks so much!


webFOCUS 8207.15
WindowsServer 2019
 
Posts: 120 | Location: Minnesota | Registered: August 26, 2013Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Refresh HTML page when *.fex changes

Copyright © 1996-2020 Information Builders