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.
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
Posts: 5 | Location: Somewhere near the Crab Nebula | Registered: September 05, 2007
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
Posts: 79 | Location: Warren, NJ, USA | Registered: October 25, 2006
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
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003
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
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003