I am creating a hold file and want to use the master file created with it to populate dropdowns in my html launch page. I can report off of the master file that is created but can't get the drop downs to populate with the master file.

Here is the fex that creates the hold:

APP HOLDMETA IBISAMP
TABLE FILE SHORT
PRINT REGION COUNTRY
ON TABLE HOLD AS DYNAMLST FORMAT FOCUS
END
-RUN

Here is the drop down code that doesn't seem to be working:

<INPUT id=ITEM2 style="Z-INDEX: 3; LEFT: 430px; WIDTH: 80px; POSITION: absolute; TOP: 190px; HEIGHT: 30px" onclick=OnRunRemoteObject[) type=button value=Button name ="button2" sourcetype="typeFex" elementname="button2" elementtype="button" IBIC_server="EDASERVE" IBIAPP_app="ibisamp" targetname="iframe1" targettype="0" onclicksource="short_test.fex" onclickset="1" variables="region;country">
<SELECT id=ITEM3 style="Z-INDEX: 4; LEFT: 10px; WIDTH: 150px; POSITION: absolute; TOP: 30px; HEIGHT: 22px" name ="region" sourcetype="typeMaster" elementname="combobox3" elementtype="combobox" labelid caption="combobox" operation="NONE" ibiformat datatype="1" addalloption="0" dynalldisplayvalue="ALL" inchainindex="1" chainnumber="0" cacheruntimedata="0" displayfield="REGION" numofrecords="-1" datafield="REGION" datasource="DYNAMLST.mas" datafieldtype="CHAR">
</SELECT>
<SELECT id=ITEM4 style="Z-INDEX: 5; LEFT: 180px; WIDTH: 150px; POSITION: absolute; TOP: 30px; HEIGHT: 22px" name ="country" sourcetype="typeMaster" elementname="combobox4" elementtype="combobox" labelid caption="combobox" operation="NONE" ibiformat datatype="1" addalloption="0" dynalldisplayvalue="ALL" inchainindex="2" chainnumber="0" cacheruntimedata="0" displayfield="COUNTRY" numofrecords="-1" datafield="COUNTRY" datasource="DYNAMLST.mas" datafieldtype="CHAR">
</SELECT>

The html is pointing to the DYNAMLST master and also the correct fields region/country however nothing appears in the drop downs.

Any Ideas? Thanks in advance!

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

ryan, you need to surround your html bits with code tags so that it will show up properly on this board, and also you have a 'button' popping up on the first line of your code..whatever is under that needs to be surrounded in code tags as well.

Let me try again. Thanks Susannah.

I am creating a hold file and want to use the master file created with it to populate dropdowns in my html launch page. I can report off of the master file that is created but can't get the drop downs to populate with the master file.

Here is the fex that creates the hold:

APP HOLDMETA IBISAMP
TABLE FILE SHORT
PRINT REGION COUNTRY
ON TABLE HOLD AS DYNAMLST FORMAT FOCUS
END
-RUN

Here is the drop down code that doesn't seem to be working:

 <INPUT id=ITEM2 style="Z-INDEX: 3; LEFT: 430px; WIDTH: 80px; POSITION: absolute; TOP: 190px; HEIGHT: 30px" onclick=OnRunRemoteObject[) type=button value=Button name ="button2" sourcetype="typeFex" elementname="button2" elementtype="button" IBIC_server="EDASERVE" IBIAPP_app="ibisamp" targetname="iframe1" targettype="0" onclicksource="short_test.fex" onclickset="1" variables="region;country"><BR><SELECT id=ITEM3 style="Z-INDEX: 4; LEFT: 10px; WIDTH: 150px; POSITION: absolute; TOP: 30px; HEIGHT: 22px" name ="region" sourcetype="typeMaster" elementname="combobox3" elementtype="combobox" labelid caption="combobox" operation="NONE" ibiformat datatype="1" addalloption="0" dynalldisplayvalue="ALL" inchainindex="1" chainnumber="0" cacheruntimedata="0" displayfield="REGION" numofrecords="-1" datafield="REGION" datasource="DYNAMLST.mas" datafieldtype="CHAR"><BR></SELECT><BR><SELECT id=ITEM4 style="Z-INDEX: 5; LEFT: 180px; WIDTH: 150px; POSITION: absolute; TOP: 30px; HEIGHT: 22px" name ="country" sourcetype="typeMaster" elementname="combobox4" elementtype="combobox" labelid caption="combobox" operation="NONE" ibiformat datatype="1" addalloption="0" dynalldisplayvalue="ALL" inchainindex="2" chainnumber="0" cacheruntimedata="0" displayfield="COUNTRY" numofrecords="-1" datafield="COUNTRY" datasource="DYNAMLST.mas"  

The html is pointing to the DYNAMLST master and also the correct fields region/country however nothing appears in the drop downs.

Any Ideas? Thanks in advance!

Ryan,

Stating the obvious first, I take it that ibisamp is in your path. It normally is on default settings, but some sites will remove it as it only contains samples.

Use APP SHOWPATH in a fex to see.

Other than that, I would suggest you shorten your code into chunks that display on the screen well, otherwise Mabel will be along and do it for you! However, you might not like the results - and we might not be able to read them!!

T

first obvious item is

OnRunRemoteObject[)

Typo or coding error

Also the OnRunRemoteObject script is not in the code but I assume that's because you just posted
the input elements.

quote:

APP HOLDMETA IBISAMP
TABLE FILE SHORT
PRINT REGION COUNTRY
ON TABLE HOLD AS DYNAMLST FORMAT FOCUS
END
-RUN

You may have to run a USE command in any WebFOCUS code subsequent to the program that created the FOCUS db.

I am trying to access The FOCUS Hold file created to populate a List box...

But It is not wokring properly... My Dropdwon shows no Data....

My code is as below.

  
-SET &HIDDEN1=123;
-SET &HIDDEN2=234;

APP HOLD baseapp

TABLE FILE CAR
PRINT
CAR
BY CAR
ON TABLE HOLD AS X_CAR FORMAT FOCUS INDEX CAR
END
-RUN

-HTMLFORM BEGIN
<html>
<head>
</head>
<body>
<input type="text" value="!IBI.AMP.HIDDEN1;" id="value1">
<br />
<input type="text" value="!IBI.AMP.HIDDEN2;" id="value2">
<br/>
 <select id="combo21_combo"        name="SEL_PLAN" elementname="listbox31" elementtype="listbox" size="10"
        scaletofit="0" labelid caption="listbox31" datatype="1" addalloption="0" selectalloption="0"
        binddatasourcefpath="X_CAR;" datasource="X_CAR;" datafield="CAR" displayfield="CAR"
        numofrecords="-1" datafieldtype="CHAR" operation="OR">
  </select>
</body>
</html>
-HTMLFORM END

Any issues in it ? Any suggestions ??

Starting a New Thread... as this is quite urgent...