Hi, i want to know what set of lines i need to use at the top of the focus code so that i can view the sql code that the focus code generates.This message has been edited. Last edited by: Kerry,
7.6.7 windows PDF,EXCEL.
July 20, 2009, 01:26 PM
Francis Mariani
You really should try the fantabulous Search feature of FocalPoint, you may come up with a post like this one:
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
July 20, 2009, 01:29 PM
swati
Hey francis, i dont know what happened,but the search engine in my developer studio is not working from the last 10 days,i dont know what the problem is.
7.6.7 windows PDF,EXCEL.
July 20, 2009, 02:02 PM
swati
Hi , i am attaching a sample code,please tell me what the problem is as i am not able to see any generated sql code.
SET XRETRIEVAL=OFF SET TRACEOFF = ALL SET TRACEON = SQLAGGR//CLIENT SET TRACEON = STMTRACE//CLIENT SET TRACEON = STMTRACE/2/CLIENT SET TRACEUSER = ON -RUN
TABLE FILE EMPLOYEE PRINT LAST_NAME FIRST_NAME
HEADING "" FOOTING "" ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML END
7.6.7 windows PDF,EXCEL.
July 20, 2009, 02:08 PM
GinnyJakes
EMPLOYEE is not a relational table but rather a FOCUS file. If you use these commands against a relational table and do a view source on the page that comes up, you will see the generated SQL.
ok,will try for a relational file and see how it works.
7.6.7 windows PDF,EXCEL.
July 20, 2009, 03:58 PM
Tony A
swati,
quote:
the fantabulous Search feature of FocalPoint
Is not the same as
quote:
the search engine in my developer studio
The search to which Francis refers is the one at the top of this, and every posting list, within the Focal Point Forum.
All we ask here is that, before posting your question, you first take the time to perform a search using that link. Be inventive in your search phrases as you might verbalise differently to others.
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
July 21, 2009, 09:26 AM
swati
yes tony, i understand what fransis has suggested me. i just explained what i am facing i.e; not able to search in dev studio. i will do search b4 posting.
7.6.7 windows PDF,EXCEL.
July 21, 2009, 09:31 AM
Francis Mariani
What's today's weather like in Atlanta,GA?
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
July 21, 2009, 09:35 AM
swati
its sunny and pretty good,may i know why u are asking.
7.6.7 windows PDF,EXCEL.
July 21, 2009, 09:45 AM
swati
Hi , i am getting the following error when i try to see the sql for a relational file,please look into the code and help me...
==================================== SET XRETRIEVAL=OFF SET TRACEOFF = ALL SET TRACEON = SQLAGGR//CLIENT SET TRACEON = STMTRACE//CLIENT SET TRACEON = STMTRACE/2/CLIENT SET TRACEUSER = ON
TABLE FILE CUST03 PRINT CUSTQ03_REL_STX_01 END
WHEN I RUN THIS ,IT GIVES AN ERROR SHOWING 'ERROR PARSING THE REQUEST' NEED HELP ON THIS.....