Focal Point
Execute procudure without window?

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

June 11, 2007, 12:46 PM
.eric
Execute procudure without window?
Is there a way to execute a procedure without having a window opening? The reason I ask is becuase I created a fex with the sole purpose to append to a focus file and I don't need the HTML window saying that it executed.

I know I can write some JSP in the fex that is generated to close the window but was wondering if there was something easier?

Eric


dev: WF 7.6.5 w/IIS + Tomcat

prod: WF 7.6.5 w/IIS + Tomcat
June 11, 2007, 02:19 PM
<Tim Howard_ABCBS>
You can always use javascript and a AJAX framework to execute a procedure without opening a new window. I've got a js library and an example if you want to see how I'm doing it, just let me know.

You can also set the procedure to return in an iframe within the current html and locate the iframe off of the screen (ie give it negative z-index). This will only work if you are using iframes which is how version 7+ does it in the html editor.

Otherwise, I'd have to see an example of the code you are using to help.

Tim H.
June 11, 2007, 02:38 PM
dhagen
Schedule the request with ReportCaster


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
June 11, 2007, 03:02 PM
.eric
Nevermind, I just added this at the end of the fex:

-HTMLFORM BEGIN
[HTML]
[body onLoad="java_script:window.close[);" ]
[/BODY]
[/HTML]
-HTMLFORM END

I can't use report caster because this is being used to save parameters on a launch page.


dev: WF 7.6.5 w/IIS + Tomcat

prod: WF 7.6.5 w/IIS + Tomcat
June 12, 2007, 09:46 AM
TexasStingray
eric. an easy way is to just set the target to a hidden iframe using a DIV tag and visibility hidden, this way the user will not see it. I use this a lot for an web based IDE I have created to execute some focus code and get the results back. I do however display an animated gif so the use know it is doing something then when I get the response back I hide the gif.




Scott

The problem with hiding the iFrame is that if there's something wrong with the WebFOCUS request, you won't see the error messages.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
Francis. is right about that I in my focexec if there is an error message I have javascript that get set if there is an error and display and alert to the user.




Scott

care to share a sample of the code?
John

If you have also ETL installed you can schedule the process there, you won't get an html screen and I suppose that if you have to add to a focus file this must be done more than once.
ETL helps you doing that job unattended.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

No ETL used in this case... I have a security process that gets executed in MRE as a profile and only want "if they fail security" for a window to be seen.

Thanks for responding.