[CLOSED] (FOC1517) Unrecognized command on table hold format htmtable as
I just upgraded from 5.3.3 to 7.6.11 Developer Studio...OS 7. The following is included in several reports. IT worked fine in 5.3.3, but throws an in 7.6.11.
-FEXCEL ON TABLE PCHOLD FORMAT EXL2K -GOTO THEEXIT2;
-FEXL2 ON TABLE PCHOLD FORMAT EXL2K -GOTO THEEXIT2;
-FHTML ON TABLE HOLD FORMAT HTMLTABLE AS TOPREPT -GOTO THEEXIT;
-THEEXIT2 END -EXIT
-THEEXIT
(FOC1517) UNRECOGNIZED COMMAND ON TABLE HOLD FORMAT HTMTABLE AS TOPREPTThis message has been edited. Last edited by: Kerry,
April 24, 2012, 02:19 PM
David Briars
APP PREPENDPATH IBISAMP
TABLE FILE GGORDER
PRINT *
ON TABLE HOLD FORMAT HTMTABLE AS TOPREPT
END
-EXIT
Yields:
0 NUMBER OF RECORDS IN TABLE= 4317 LINES= 4317
0 HTML FILE SAVED ...
I think the format you are looking for is: HTMTABLE.
Typically, I code my -GOTO's as: -GOTO label
The manual doesn't mentioned ending -GOTO's with a ';'.
Are you branching around the 'END' command, when your code needs it?This message has been edited. Last edited by: David Briars,
Pilot: WebFOCUS 8.2.06 Test: WebFOCUS 8.1.05M Prod: WebFOCUS 8.1.05M Server: Windows Server 2016/Tomcat Standalone Workstation: Windows 10/IE11+Edge Database: Oracle 12c, Netezza, & MS SQL Server 2019 Output: AHTML/XLSX/HTML/PDF/JSCHART Tools: WFDS, Repository Content, BI Portal Designer & ReportCaster
April 25, 2012, 05:47 PM
Waz
I think HTMLTABLE was dropped quite awhile ago, in favour of HTMTABLE.
Another case of code tightening.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
April 25, 2012, 06:30 PM
j.gross
quote:
(FOC1517) UNRECOGNIZED COMMAND ON TABLE HOLD FORMAT HTMTABLE AS TOPREPT
But from the error message it seems the "-INCLUDE" was encountered outside the scope of a TABLE command.
The complaint is not that the line does not conform to TABLE syntax, but rather that the WF agent was rummaging through FOCSTACK looking for a Focus primary command, and instead found
ON TABLE HOLD ...
April 25, 2012, 06:35 PM
j.gross
Try EX whatever ECHO=ON,STACK=OFF[,param=value,...]
April 25, 2012, 06:40 PM
Waz
I think we need to see the code and/or the code output, as per Jacks suggestion.