[SOLVED] (FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND
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
October 20, 2017, 11:24 AM
If the fex is in the repository you can reference it like this:
form action="/ibi_apps/WFServlet" method="get" input type="hidden" name="IBIF_ex" value="country_cars.fex"
I believe with that set of execution parameters the reporting server will expect the fex to reside on the server, not in "content" on the client.
- Jack Gross WF through 8.1.05
October 20, 2017, 11:32 AM
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,