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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
I've been working and searching on this for a couple of hours and it's time to ask for help.
I have a simple form with a single text box input.
-DEFAULTH &COUNTRY = '_FOC_NULL'
<form action="/ibi_apps/WFServlet" method="get">
<input type="hidden" name="IBIF_ex" value="country_cars.fex">
Enter the NPI Number (a partial num will return multiple rows):
<input type="EDIT" name="COUNTRY" value="">
I'd like to enter a number (ex: 10) as the input and then call a pretty simple procedure, passing the parameter.
-DEFAULT &COUNTRY = '_FOC_NULL'
TABLE FILE CAR
WHERE COUNTRY EQ '&COUNTRY'
Both files are in the same content directory, right off the content root. But, WF can not find the procedure.
How do I help it?This message has been edited. Last edited by: Don Garland,
When you run a WFServlet request the way you have it coded, it is looking for the procedures on the reporting server in any app folder in the APP PATH. I think there is a way to run WFServlet pointing to the content area but not sure what the syntax is.
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
Posts: 2128 | Location: Customer Support | Registered: April 12, 2005
it is looking for the procedures on the reporting server in any app folder in the APP PATH.
I thought of that and put the fex in a few locations within the app path but it still doesn't find it. Back in 7.65 we used to set a series of variables. That method was given to me by an IBI Prof Serv person at DG and it worked but I can't find documentation that matches that method for 8.09.
My first efforts were to get this to work in HTML Composer. And if the FEX is in the HTML Document, it works and it's fast to put together, but calling an external fex and passing an input variable seems to be more difficult.
NOTE: WF does find the fex if I save it to baseapp. This validates what was suggested but I'm hoping to find a configuration solution to this.
Honestly, a HTML Composer solution would be the best way to get this done. Just like adding a report to an HTML document which does allow me to pass parameters to it (or set them and refresh would be more accurate).This message has been edited. Last edited by: Don Garland,