Auto-refresh report

I'm relatively new to WF and am trying to create a report that will auto-refresh the content after a pre-determined interval. I can use in HTML or can use a Javascript snippet of code to do the same. Outside of WF, it works. Embedding either pieces of code in a WF HTML doc doesn't. I get "No query information to decode." when it refreshes. Any suggestions?

WebFocus 7.1.4
Windows XP/Intel
HTML, Excel, PDF

Posts: 6 | Registered: November 26, 2007

Francis Mariani

Expert

posted

Hide Post

Here's a WebFOCUS program that refreshes every two seconds:

TABLE FILE CAR
SUM
SALES
BY COUNTRY
HEADING
"CAR REFRESH TEST"
"AT &TOD"
ON TABLE HOLD AS H001 FORMAT HTMTABLE
END
-RUN

-HTMLFORM BEGIN
<html>
<head>
<script language="JavaScript">
function doReload()
{
setTimeout( "location.reload(true);", 2*1000 );
}
</script>
</head>

<body onLoad="doReload();">
!IBI.FIL.H001;
</body>
</html>
-HTMLFORM END

I call it with this URL:

http://server-name/ibi_apps/WFServlet?&IBIF_ex=fmreload1

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

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Show Post

Rob

Member

posted

Hide Post

Thanks. Let me give that a shot. It looks similar to the code I tried using javascript:
<script language="JavaScript">
< !--
var time = null
function move() {
window.location.Reload
}
//-->

I'll post whether it works or not. Thanks again.

WebFocus 7.1.4
Windows XP/Intel
HTML, Excel, PDF

Posts: 6 | Registered: November 26, 2007

Ignored post by Rob posted

Show Post

Rob

Member

posted

Hide Post

Francis,
It worked like a champ. Thanks!! I used this code:

END
-RUN
-HTMLFORM BEGIN
<html>
<head>
<META HTTP-EQUIV=REFRESH CONTENT=10;URL="http://myserver/ibi_apps/WFServlet?IBIF_ex=xyz">
</head>
<body >
</body>
</html>
-HTMLFORM END

at the end of the FOCEXEC stmts. One anomaly-I couldn't use the name that WebFOCUS created when the .fex file was created. I had to change it from z04r1hvi.fex to xyz.fex (just to get it to work) and figure out through trial and effort the directory in which I had to copy the .fex file. I really appreciate your assistance on this.

This message has been edited. Last edited by: Rob,

WebFocus 7.1.4
Windows XP/Intel
HTML, Excel, PDF

Posts: 6 | Registered: November 26, 2007

Ignored post by Rob posted

Show Post

Francis Mariani

Expert

posted

Hide Post

Rob,

Please edit your previous message and put your code between

[code]

[/code]

tags - the posting is actually performing the refresh!

Are you using MRE?

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

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Show Post

susannah

Expert

posted

Hide Post

sweet!