Focal Point
IBI.FIL not being found

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

February 03, 2009, 03:16 PM
Les
IBI.FIL not being found
I'm trying to use the !IBI.FIL.myfile; to load a dropdown box in an html file that was created using the html layout painter and being executed from the BID. The dropdown box does not get populated and the source reveals this error, "(FOC36225) UNABLE TO OPEN FILE myfile SPECIFIED BY WEBFOCUS TABLE".

If I filedef the hold file and insert the html code within a -HTMLFORM in that focexec, my dropdown box is populated.

Does the IBI.FIL only work within an -HTMLFORM?


7.7.03
February 03, 2009, 04:13 PM
Diptesh Patel
Les:
Yes, the !IBI.FIL (and all other !IBI. whatevers) are special HTML tags that are recognized by WebFOCUS. Due to that, they are only recognized thru the -HTMLFORM. In a nutshell, the html in a -HTMLFORM section is actually interpreted by the Focexec, prior to sending it back to the web server.


Diptesh
WF 7.1.7 - AIX, MVS
February 03, 2009, 10:41 PM
susannah
Les, you want an XML file
TABLE FILE SOMETHING
SUM MYDESCRIPTION BY MYCODE
ON TABLE PCHOLD FORMAT XML
END
..now open your launch page in the Composer (what used to be called the layout painter), click on the dropdown box (you're in version 7x, i'm guessing yes?) and you have a choice of a static dropdown, using a master file, or a dynamic one using a fex. Select the fex choice
and then specify the name of this little fex you just wrote.
(or just use the master file choice, if that works for you!)
If you're still in v5, ummm, upgrade.
And edit your signature (in your profile)here on the point so we know what versions/platforms you're on.



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
February 04, 2009, 10:43 AM
susannah
having said that...
if your drop downs are simple and you don't want to chain them, and you don't want to use the XML and AJAX that comes along with the new flavor of launch pages, there is a way to still use your !IBI.FIL.s and get your old launches to work...
..
if your make your launch page a fex
(yes, you can do that, as Diptesh says)
TABLE FILE WHATEVER
..build your text file of option tags
..and maybe with those nice optgroup labels
ON TABLE HOLD AS MYDROP FORMAT ALPHA
END
-RUN
-HTMLFORM BEGIN
<html>
... paste your old launch page   here
... stick in your bang bits where you need them
!IBI.FIL.MYDROP;
...rest of your old v5 launch page stuff
</html>
-HTMLFORM END