As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at email@example.com and provide your corporate email address, company, and name.
I am trying to create variables using a 1 record HOLD file.
I get the following error:
0 ERROR AT OR NEAR LINE 42 IN PROCEDURE invoice_detail_subsidiary_daily (FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: COMPHOLD 0 ERROR AT OR NEAR LINE 43 IN PROCEDURE invoice_detail_sub (FOC2907) ERROR WITH DIALOGUE MANAGER COMMAND: -READFILE COMPHOLD
Code that I am trying to run:
TABLE FILE COMPANY_LOCATION PRINT FFA_DAY_END FFA_FISCAL_WEEK FFA_FISCAL_PERIOD FFA_FISCAL_YEAR ON TABLE SET PAGE-NUM NOLEAD ON TABLE NOTOTAL ON TABLE HOLD AS COMPHOLD ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = endeflt, $ TYPE=REPORT, GRAPHCOLOR='GREEN', $ TYPE=REPORT, OBJECT=MENU, COLOR='WHITE', HOVER-COLOR=RGB(66 70 73), BACKCOLOR=RGB(102 102 102), HOVER-BACKCOLOR=RGB(218 225 232), BORDER-COLOR='WHITE', $ TYPE=REPORT, OBJECT=STATUS-AREA, COLOR='WHITE', BACKCOLOR=RGB(102 102 102), $ TYPE=REPORT, OBJECT=CURRENT-ROW, HOVER-BACKCOLOR=RGB(218 225 232), BACKCOLOR=RGB(200 200 200), $ TYPE=REPORT, OBJECT=CALC-AREA, COLOR='WHITE', BACKCOLOR=RGB(102 102 102), $ ENDSTYLE END -READFILE COMPHOLD -TYPE FFA_DAY_END IS &DE -TYPE FFA_FISCAL_WEEK IS &FW -TYPE FFA_FISCAL_PERIOD IS &FP -TYPE FFA_FISCAL_YEAR IS &FYThis message has been edited. Last edited by: Kerry,
WebFocus 8.1.5 iSeries/Windows DB2/SQL/Access Dev Studio App Studio Maintain ReportCaster
Posts: 341 | Location: Pembroke NH/Jericho NY | Registered: June 15, 2011
format is typically Ann, where nnis the length of the string to get.
If you issue a ? HOLD COMPHOLD you will see the lengths of the fields.
Unless you are going to use the file COMPHOLD later in your fex, I would suggest using ON TABLE SAVE AS COMPHOLD, as this creates an alpha version of the file anyway, and also shows the field sizes in the output making it easier to work out the -READ.
jay, get rid of all that stylesheet noise..it has no part of this task. I would have issued a -READ filename varname.size i can't wait to upgrade and find out about this walk in the park -READFILE... tks new jersey!
TABLE FILE COMPANY_LOCATION PRINT FFA_DAY_END FFA_FISCAL_WEEK FFA_FISCAL_PERIOD FFA_FISCAL_YEAR ON TABLE HOLD AS COMPHOLD FORMAT ALPHA END -RUN
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003
I've found the GUI tools in 7.7.03M doing a more decent job than in previous versions (particularly the Synonym Editor and the JOIN /MATCH Tool) so I'm seeing myself using the GUI to scaffold my reports more frequently than in the past.
Dev Studio's Report Painter could do a better job at *not* adding any STYLE statements (which susannah accurately calls "noise") when choosing a non-styled output format such as HOLD BINARY, HOLD ALPHA, HOLD FOCUS, etc.
TABLE FILE EMPLOYEE
PRINT LAST_NAME FIRST_NAME DEPARTMENT CURR_SAL
ON TABLE HOLD AS READF1 FORMAT BINARY
-TYPE LAST_NAME IS &LAST_NAME
-TYPE FIRST_NAME IS &FIRST_NAME
-TYPE DEPARTMENT IS &DEPARTMENT
-TYPE CURR_SAL IS &CURR_SAL
-TYPE EMP_ID IS &EMP_ID
They used BINARY.
Posts: 60 | Location: Ellensburg Washington | Registered: May 22, 2009