Focal Point
[SOLVED]calling a fex from a WebFOCUS html form

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

February 18, 2009, 04:57 AM
pink
[SOLVED]calling a fex from a WebFOCUS html form
Hi All,
I don't know how to call a fex file from a WebFOCUS UI. I searched it, and from what i got, tried to implement that in my case, but received an error. The code for my html form goes like this:-

<!-- Generated by Report Layout Painter -->
<HTML>
<HEAD>
<TITLE>HtmlPage
</TITLE>
<BASE href=HTTP://webfadh.target.com:80>
<SCRIPT id=clientEventHandlersJS type=text/javascript>
function window_onload() {
UpdateData();
// TODO: Add your event handler code here
  document.getElementById("listbox15").style.display='none';
        document.getElementById("listbox16").style.display='none';
  document.getElementById("listbox17").style.display='none';
        document.getElementById("text16").style.display='none';
        document.getElementById("text15").style.display='none';
  document.getElementById("text13").style.display='none';
}
function comboSelect() {
timeframe = form1.combobox1.value;
 
 if(timeframe=="Monthly")
 {
  document.getElementById("listbox15").style.display='none';
        document.getElementById("listbox16").style.display='none';
  document.getElementById("listbox17").style.display='block';
        document.getElementById("text15").style.display='none';
        document.getElementById("text16").style.display='none';
  document.getElementById("text13").style.display='block';
 }
 else if(timeframe=="Quarterly")
 {
  document.getElementById("listbox15").style.display='none';
        document.getElementById("listbox16").style.display='block';
  document.getElementById("listbox17").style.display='none';
        document.getElementById("text16").style.display='none';
        document.getElementById("text15").style.display='block';
  document.getElementById("text13").style.display='none';
 }
 else if(timeframe=="Seasonal")
 {
  document.getElementById("listbox15").style.display='block';
        document.getElementById("listbox16").style.display='none';
  document.getElementById("listbox17").style.display='none';
        document.getElementById("text16").style.display='block';
        document.getElementById("text15").style.display='none';
  document.getElementById("text13").style.display='none';
 }
    else
 {
  document.getElementById("listbox15").style.display='none';
        document.getElementById("listbox16").style.display='none';
  document.getElementById("listbox17").style.display='none';
        document.getElementById("text16").style.display='none';
        document.getElementById("text15").style.display='none';
  document.getElementById("text13").style.display='none';
 }
}
 
 
function button5_onclick(ctrl) {
OnExecute(ctrl)
}
</SCRIPT>

<SCRIPT for=window eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>

<META content="MSHTML 6.00.3790.4426" name=GENERATOR>
</HEAD>
<BODY style="OVERFLOW: auto; BORDER-TOP-STYLE: none; BORDER-RIGHT-STYLE: none; BORDER-LEFT-STYLE: none; BACKGROUND-COLOR: white; BORDER-BOTTOM-STYLE: none">
<FORM id=form1 name=vpf_rpt_form>
<INPUT id=button1 style="Z-INDEX: 35; LEFT: 280px; POSITION: absolute; TOP: 140px" tabIndex=35 type=button value=">>" name=">"> 
<INPUT id=button2 style="Z-INDEX: 36; LEFT: 280px; POSITION: absolute; TOP: 340px" tabIndex=36 type=button value=">>" name=">"> 
<INPUT id=button3 style="Z-INDEX: 36; LEFT: 280px; POSITION: absolute; TOP: 170px" tabIndex=36 type=button value=. name=.> 
<INPUT id=button4 style="Z-INDEX: 36; LEFT: 280px; POSITION: absolute; TOP: 380px" tabIndex=36 type=button value=. name=.> 
<SPAN id=text9 style="FONT-WEIGHT: bold; Z-INDEX: 26; LEFT: 370px; WIDTH: 150px; POSITION: absolute; TOP: 730px; HEIGHT: 38px; BACKGROUND-COLOR: white" tabIndex=26>Merchandise Vendor 
</SPAN>
<SPAN id=text16 style="FONT-WEIGHT: bold; Z-INDEX: 34; LEFT: 870px; WIDTH: 150px; POSITION: absolute; TOP: 840px; HEIGHT: 38px; BACKGROUND-COLOR: white" tabIndex=34>Season 
</SPAN>
<SPAN id=text15 style="FONT-WEIGHT: bold; Z-INDEX: 33; LEFT: 620px; WIDTH: 150px; POSITION: absolute; TOP: 840px; HEIGHT: 38px; BACKGROUND-COLOR: white" tabIndex=33>Quarter 
</SPAN>
<SPAN id=text14 style="FONT-WEIGHT: bold; Z-INDEX: 32; LEFT: 80px; WIDTH: 150px; POSITION: absolute; TOP: 840px; HEIGHT: 38px; BACKGROUND-COLOR: white" tabIndex=32>Year 
</SPAN>
<SPAN id=text8 style="FONT-WEIGHT: bold; Z-INDEX: 25; LEFT: 370px; WIDTH: 150px; POSITION: absolute; TOP: 610px; HEIGHT: 38px; BACKGROUND-COLOR: white" tabIndex=25>Fabric Suppplier 
</SPAN>
<SPAN id=text13 style="FONT-WEIGHT: bold; Z-INDEX: 31; LEFT: 370px; WIDTH: 150px; POSITION: absolute; TOP: 840px; HEIGHT: 38px; BACKGROUND-COLOR: white" tabIndex=31>Month 
</SPAN>
<SPAN id=text11 style="FONT-WEIGHT: bold; Z-INDEX: 28; LEFT: 620px; WIDTH: 150px; POSITION: absolute; TOP: 730px; HEIGHT: 38px; BACKGROUND-COLOR: white" tabIndex=28>Time Frame 
</SPAN>
<SPAN id=text12 style="FONT-WEIGHT: bold; Z-INDEX: 29; LEFT: 620px; WIDTH: 150px; POSITION: absolute; TOP: 610px; HEIGHT: 38px; BACKGROUND-COLOR: white" tabIndex=29>Fabric Subtype 
</SPAN>
<SPAN id=text3 style="FONT-WEIGHT: bold; Z-INDEX: 7; LEFT: 80px; WIDTH: 150px; POSITION: absolute; TOP: 270px; HEIGHT: 38px; BACKGROUND-COLOR: white" tabIndex=7>Available Metrics 
</SPAN>
<SPAN id=text7 style="FONT-WEIGHT: bold; Z-INDEX: 24; LEFT: 90px; WIDTH: 150px; POSITION: absolute; TOP: 610px; HEIGHT: 38px; BACKGROUND-COLOR: white" tabIndex=24>Fabrication 
</SPAN>
<SELECT id=listbox14 style="Z-INDEX: 18; LEFT: 60px; WIDTH: 200px; POSITION: absolute; TOP: 870px; HEIGHT: 60px" tabIndex=18 size=3 name=year_listbox ibiapp_app IBIMR_folder="#metricrptjsy" sourcetype="typeFex" operation="NONE" datatype="1" datafield displayfield datasource="app/slsilhou.fex">
</SELECT> 
<SELECT id=listbox17 style="Z-INDEX: 21; LEFT: 340px; WIDTH: 200px; POSITION: absolute; TOP: 870px; HEIGHT: 60px" tabIndex=21 size=3 name=month_listbox> 
<OPTION value=Feb selected displaytext="Feb">Feb
</OPTION> 
<OPTION value=Mar displaytext="Mar">Mar
</OPTION> 
<OPTION value=Apr displaytext="Apr">Apr
</OPTION> 
<OPTION value=May displaytext="May">May
</OPTION> 
<OPTION value=Jun displaytext="Jun">Jun
</OPTION> 
<OPTION value=Jul displaytext="Jul">Jul
</OPTION> 
<OPTION value=Aug displaytext="Aug">Aug
</OPTION> 
<OPTION value=Sep displaytext="Sep">Sep
</OPTION> 
<OPTION value=Oct displaytext="Oct">Oct
</OPTION> 
<OPTION value=Nov displaytext="Nov">Nov
</OPTION> 
<OPTION value=Dec displaytext="Dec">Dec
</OPTION>
</SELECT> 
<SELECT id=listbox16 style="Z-INDEX: 20; LEFT: 600px; WIDTH: 200px; POSITION: absolute; TOP: 870px; HEIGHT: 60px" tabIndex=20 size=3 name=quarter_listbox> 
<OPTION value=Feb,Mar,Apr selected displaytext="Quarter-1">Quarter-1
</OPTION> 
<OPTION value=May,Jun,Jul displaytext="Quarter-2">Quarter-2
</OPTION> 
<OPTION value=Aug,Sep,Oct displaytext="Quarter-3">Quarter-3
</OPTION> 
<OPTION value=Nov,Dec,Jan displaytext="Quarter-4">Quarter-4
</OPTION>
</SELECT> 
<SELECT id=listbox10 style="Z-INDEX: 14; LEFT: 60px; WIDTH: 200px; POSITION: absolute; TOP: 760px; HEIGHT: 60px" tabIndex=14 size=3 name=silhoute_group_listbox ibiapp_app IBIMR_folder="#metricrptjsy" sourcetype="typeFex" datatype="1" datafield displayfield datasource="app/kn43wry5.fex">
</SELECT> 
<SELECT id=listbox9 style="Z-INDEX: 13; LEFT: 340px; WIDTH: 200px; POSITION: absolute; TOP: 760px; HEIGHT: 60px" tabIndex=13 size=3 name=merchandise_vendor_listbox ibiapp_app IBIMR_folder="#metricrptjsy" sourcetype="typeFex" datatype="1" datafield displayfield datasource="app/ko3rqbue.fex">
</SELECT> 
<SELECT id=listbox7 style="Z-INDEX: 11; LEFT: 340px; WIDTH: 200px; POSITION: absolute; TOP: 640px; HEIGHT: 60px" tabIndex=11 size=3 name=fabric_supplier_listbox ibiapp_app IBIMR_folder="#metricrptjsy" sourcetype="typeFex" datatype="1" datafield displayfield datasource="app/diyn41nm.fex">
</SELECT> 
<SELECT id=listbox11 style="Z-INDEX: 15; LEFT: 600px; WIDTH: 200px; POSITION: absolute; TOP: 640px; HEIGHT: 60px" tabIndex=15 size=3 name=fabric_subtype_listbox ibiapp_app IBIMR_folder="#metricrptjsy" sourcetype="typeFex" datatype="1" datafield displayfield datasource="app/n65r2kzo.fex">
</SELECT> 
<SELECT id=listbox15 style="Z-INDEX: 19; LEFT: 860px; WIDTH: 200px; POSITION: absolute; TOP: 870px; HEIGHT: 60px" tabIndex=19 size=3 name=season_listbox> 
<OPTION value=Feb,Mar,Apr,May,Jun,Jul selected displaytext="Spring">Spring
</OPTION> 
<OPTION value=Aug,Sep,Oct,Nov,Dec,Jan displaytext="Fall">Fall
</OPTION>
</SELECT> 
<SELECT id=listbox8 style="Z-INDEX: 12; LEFT: 60px; WIDTH: 200px; POSITION: absolute; TOP: 640px; HEIGHT: 60px" tabIndex=12 size=3 name=fabrication_listbox ibiapp_app IBIMR_folder="#metricrptjsy" sourcetype="typeFex" datatype="1" datafield displayfield datasource="app/vf47qjjl.fex">
</SELECT> 
<SELECT id=listbox1 style="Z-INDEX: 1; LEFT: 60px; WIDTH: 200px; POSITION: absolute; TOP: 120px; HEIGHT: 110px" tabIndex=1 multiple size=3 name=available_grpng_listbox ibiapp_app IBIMR_folder="#metricrptjsy" sourcetype="typeFex" operation="OR" datatype="0" datafield displayfield datasource> 
<OPTION value=Value selected displaytext="Value">Value
</OPTION> 
<OPTION value=Value displaytext="Value">Value
</OPTION> 
<OPTION value=Value displaytext="Value">Value
</OPTION>
</SELECT> 
<SPAN id=text1 style="FONT-WEIGHT: bold; Z-INDEX: 5; LEFT: 80px; WIDTH: 150px; POSITION: absolute; TOP: 90px; HEIGHT: 38px; BACKGROUND-COLOR: white" tabIndex=5>Available Grouping 
</SPAN>
<SPAN id=text4 style="FONT-WEIGHT: bold; Z-INDEX: 8; LEFT: 360px; WIDTH: 150px; POSITION: absolute; TOP: 270px; HEIGHT: 38px; BACKGROUND-COLOR: white" tabIndex=8>Selected Metrics 
</SPAN>
<SPAN id=text10 style="FONT-WEIGHT: bold; Z-INDEX: 27; LEFT: 80px; WIDTH: 150px; POSITION: absolute; TOP: 730px; HEIGHT: 48px; BACKGROUND-COLOR: white" tabIndex=27>SL Silhouette Group 
</SPAN>
<SELECT id=listbox3 style="Z-INDEX: 3; LEFT: 60px; WIDTH: 200px; POSITION: absolute; TOP: 300px; HEIGHT: 250px" tabIndex=3 multiple size=3 name=availble_metrics_listbox operation="OR"> 
<OPTION value="LY Qty SQ yards" selected displaytext="LY Qty SQ yards">LY Qty SQ yards
</OPTION> 
<OPTION value="LY Qty LBS" displaytext="LY Qty LBS">LY Qty LBS
</OPTION> 
<OPTION value="LY consumption/Unit SQ yards" displaytext="LY consumption/Unit SQ yards">LY consumption/Unit SQ yards
</OPTION> 
<OPTION value="LY consumption/Unit LBS" displaytext="LY consumption/Unit LBS">LY consumption/Unit LBS
</OPTION> 
<OPTION value="LY Quantity" displaytext="LY Quantity">LY Quantity
</OPTION> 
<OPTION value="LY First Cost" displaytext="LY First Cost">LY First Cost
</OPTION> 
<OPTION value="LY Estimated Landed Cost" displaytext="LY Estimated Landed Cost">LY Estimated Landed Cost
</OPTION> 
<OPTION value="Plan Quantity SQ Yards" displaytext="Plan Quantity SQ Yards">Plan Quantity SQ Yards
</OPTION> 
<OPTION value="Plan Quantity LBS" displaytext="Plan Quantity LBS">Plan Quantity LBS
</OPTION> 
<OPTION value="Plan Consumption/Unit SQ Yards" displaytext="Plan Consumption/Unit SQ Yards">Plan Consumption/Unit SQ Yards
</OPTION> 
<OPTION value="Plan Consumption/Unit LBS" displaytext="Plan Consumption/Unit LBS">Plan Consumption/Unit LBS
</OPTION> 
<OPTION value="Plan Quantity" displaytext="Plan Quantity">Plan Quantity
</OPTION> 
<OPTION value="Plan First Cost" displaytext="Plan First Cost">Plan First Cost
</OPTION> 
<OPTION value="Plan Estimated Landed Cost" displaytext="Plan Estimated Landed Cost">Plan Estimated Landed Cost
</OPTION>
</SELECT> 
<SELECT id=listbox4 style="Z-INDEX: 4; LEFT: 340px; WIDTH: 200px; POSITION: absolute; TOP: 300px; HEIGHT: 260px" tabIndex=4 multiple size=3 name=slctd_metrics_listbox operation="OR">
</SELECT> 
<SELECT id=listbox2 style="Z-INDEX: 2; LEFT: 340px; WIDTH: 200px; POSITION: absolute; TOP: 120px; HEIGHT: 110px" tabIndex=2 multiple size=3 name=slctd_grpng_listbox operation="OR">
</SELECT> 
<SPAN id=text2 style="FONT-WEIGHT: bold; Z-INDEX: 6; LEFT: 370px; WIDTH: 150px; POSITION: absolute; TOP: 90px; HEIGHT: 38px; BACKGROUND-COLOR: white" tabIndex=6>Selected Grouping 
</SPAN>
<SELECT id=combobox1 style="Z-INDEX: 30; LEFT: 600px; WIDTH: 200px; POSITION: absolute; TOP: 760px" tabIndex=30 onchange=comboSelect() name=time_frame_combobox> 
<OPTION value=Annual selected displaytext="Annual">Annual
</OPTION> 
<OPTION value=Monthly displaytext="Monthly">Monthly
</OPTION> 
<OPTION value=Quarterly displaytext="Quarterly">Quarterly
</OPTION> 
<OPTION value=Seasonal displaytext="Seasonal">Seasonal
</OPTION>
</SELECT> 
<INPUT language=javascript id=button5 style="FONT-WEIGHT: bold; Z-INDEX: 39; LEFT: 70px; WIDTH: 130px; COLOR: white; POSITION: absolute; TOP: 1000px; HEIGHT: 30px; BACKGROUND-COLOR: gray" onclick=button5_onclick(this) tabIndex=39 type=button size=13 value="Generate Report" name=button5 requests_list="1"> 
</FORM>
<INPUT id=edit1 style="FONT-WEIGHT: bold; FONT-SIZE: 12pt; Z-INDEX: -1; LEFT: 60px; WIDTH: 310px; COLOR: gray; POSITION: absolute; TOP: 34px; HEIGHT: 36px; BACKGROUND-COLOR: transparent" tabIndex=42 size=31 value="Available Grouping and Metric Report" name=edit1> 
<xml id=ibi_requests>
<requests>
<request requestid="1" sourcetype="typeFex" targettype="1" targetname="_blank" IBIMR_folder="#testpgntp4yx" ibif_ex="app/newcar.fex" ibiapp_app="">
</request>
</requests>
</xml>
</BODY>
</HTML>


this html file named 'newhtm.htm' is present in 'HTML Files' folder. My requirement is that I have a button on this form 'button5', on clicking which, a fex file named 'newcar.fex', which is present in 'Procedures' folder should invoked and execute.

so for calling the fex file, I used this. Actually I just copied it from an example, so don't know what all attributes stand for and what is the proper syntax:-

<xml id=ibi_requests>
<requests>
<request requestid="1" sourcetype="typeFex" targettype="1" targetname="_blank" IBIMR_folder="#testpgntp4yx" ibif_ex="app/newcar.fex" ibiapp_app="">
</request>
</requests>
</xml>


The code for my fex file is:-

TABLE FILE CAR
PRINT
COUNTRY
CAR
END
-EXIT


When m clicking on the button to get the fex file executed. It is displaying error which reads- 
(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: app/newcar


I searched on the forum for the relevant info, but probably am using inappropriate keywords.

So please help! Its pretty urgent.

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


Thanks and Regards,

WF 7611
XFOCUS/FOCUS DB
Win XP
EXL2K/HTML
February 18, 2009, 07:22 AM
pink
Hey.!
I found the solution and its working fine now. Smiler


Thanks and Regards,

WF 7611
XFOCUS/FOCUS DB
Win XP
EXL2K/HTML
February 11, 2010, 01:17 PM
bhadraavantsa
quote:
ibif_ex


Could you please let us know the solution for this,

I get a message saying WEBFOCUS called with an invalid request


Windows XP/ 7.6.* -
All Formats
February 13, 2010, 04:05 AM
<paul_doughty_ibi>
http://servername/ibi_apps/WFS...=AVALUE&PARM2=AVALUE

This will all you to call 'nameoffex.fex' passing &PARM1 and &PARM2 ...

Hope that helps
Paul