April 20, 2006, 01:41 PM
reFOCUSingDisplaying system information
I have a fex that displays a report on the status of the db and scheme it was ran against. This is all done via a dynamic SQL connection and SQL pass-through. This works great but now the testing team wants more. They want the report to display the version of WF that the report was on and which appath the report was ran from.
I know that using ? RELEASE and ? PATH will give them the information they want but there is a problem with that. To see the information from these system query options they have to view the source on the HTML page.
So my question does anyone know a way to display this information on a report?
Here is an example of what I'm talking about:
? RELEASE
? PATH
-RUN
TABLE FILE CAR
SUM
RETAIL_COST
BY COUNTRY
END
-RUN
April 20, 2006, 04:31 PM
Francis MarianiHalf of half the solution:
Based on the HTML document,
http://documentation.informationbuilders.com/masterinde...adm532/05Access3.htm(You'll need to login to Tech Support) I came up with this fex that should give you the App Path, except, it was unreadable - the Master FOCAPPQ does not match the file FOCAPPL. There's a typo in the HTML document, so I changed the master to FOCAPPL and that worked.
FILEDEF FOCAPPL DISK FOCAPPL.FTM
APP LIST HOLD
TABLE FILE FOCAPPL
PRINT *
END
-RUN
Problem is, it gives you a list of folders in the approot directory - some of those may not be added to the App Path.
RELEASE I'm still looking into.
Cheers,
Francis.
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