Focal Point
[CLOSED] (FOC1517) Unrecognized command on table hold format htmtable as

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

April 24, 2012, 01:46 PM
db
[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.

I have not been able to pinpoint a syntax change.

Why does this not work in 7.6.11?


-DEFAULT &FORMT = 'HTML';

-IF &FORMT EQ 'PDF' GOTO FPDF;
-IF &FORMT EQ 'HTML' GOTO FHTML;
-IF &FORMT EQ 'EXCEL' GOTO FEXCEL;
-IF &FORMT EQ 'EXL2K' GOTO FEXL2;
-GOTO THEEXIT;

-FPDF
ON TABLE PCHOLD FORMAT PDF
-GOTO THEEXIT;

-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 TOPREPT

This 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.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs: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.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!