Focal Point
How do you view Focus Generated SQL?

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

April 22, 2005, 01:57 PM
secret
How do you view Focus Generated SQL?
In old FOCUS you could allocate fstrace. Is there an equiilaant method in WEBFOCUS?
April 22, 2005, 02:33 PM
<JG>
If you have access to the webconsole and admin privileges then you can turn on the tracing dynamically there. When viewing the traces you can filter them so that you can just look at the SQl.
April 22, 2005, 03:15 PM
RB
These commands would help view the SQL in view source.

SET TRACEON = SQLAGGR//CLIENT
SET TRACEON = STMTRACE//CLIENT
SET TRACEUSER = ON
April 22, 2005, 03:50 PM
dwf
Try this:

SET TRACEOFF = ALL
SET TRACEON = SQLAGGR//CLIENT
SET TRACEON = STMTRACE//CLIENT
SET TRACEON = STMTRACE/2/CLIENT
SET TRACEUSER = ON

Then View Source after your run
April 22, 2005, 03:59 PM
<JG>
add

SET XRETRIEVAL=OFF

It will generate the SQL without actually running the request and the SQL will come directly back to the browser.