Focal Point
Checking logic prior to execution

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

April 25, 2007, 01:17 PM
<Edgare>
Checking logic prior to execution
Hi

Is there a way to have focus check the entire logic of the query before it runs it? I have a huge query with dozen sections that create data dump files... Usually it executes then half way down it find an error with something. Is there a way for it to check the entire code before executing it?

Thanks

Edgar


Running focus FOCUS 6.9.8 on Open VMS.
April 25, 2007, 01:32 PM
RB
If you just want to check for the general coding errors, add
SET XRETRIEVAL = OFF on the first line of your query
this would not execute the query and just checks for the coding errors.
April 25, 2007, 01:49 PM
Francis Mariani
The only problem I've found with SET XRETRIEVAL=OFF is that the agent crashes when a complex program has MORE FILE - I cannot reproduce the error at the moment...

Very annoying, so hopefully this has been fixed in versions newer than 5.3.2.


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
April 25, 2007, 02:08 PM
<Edgare>
quote:
SET XRETRIEVAL = OFF

Thanks Worked Great!