October 16, 2007, 10:02 AM
vkrugmanerror-UNKNOWN KEYWORD IN STYLESHEET FILE AT LINE
Please help! Keep getting this 0 NUMBER OF RECORDS IN TABLE= 4 LINES= 1
0 NUMBER OF RECORDS IN TABLE= 403916 LINES= 1
0 NUMBER OF RECORDS IN TABLE= 1293 LINES= 156
(BEFORE TOTAL TESTS)
0 NUMBER OF RECORDS IN TABLE= 4 LINES= 4
0 NUMBER OF RECORDS IN TABLE= 4 LINES= 1
0 NUMBER OF RECORDS IN TABLE= 444 LINES= 3
0 NUMBER OF RECORDS IN TABLE= 3 LINES= 1
(FOC3209) UNKNOWN KEYWORD IN STYLESHEET FILE AT LINE: 2 SET PCHOLD-FMT
RUNTIME: 00:00:33
This line gets generated every time in my program after I delete it. When I run my procedure from WF Developer Studio, it works, BUT WHen I delete this line and run it from our application server that error keeps comming back! Please advise!
October 16, 2007, 10:11 AM
LeahWithout knowing what version you are using it makes it difficult to help, can you post the segment of code giving the error. It appears you may be deleting something else which shows the start of the styling.
October 16, 2007, 10:21 AM
vkrugmanthis line SET PCHOLD-FMT=BINARY :
COMPUTE
IX/P5.2=C4T3/C4T4; AS '' IN 101 OVER
SUBT8 AS '' IN 10 OTT1 AS '' IN 34 OTT2 AS '' IN 49
COMPUTE
IX/P5.2=OTT1/OTT2; AS '' IN 58
OTT3 AS '' IN 75 OTT4 AS '' IN 91
COMPUTE
IX/P5.2=OTT3/OTT4; AS '' IN 101 OVER
BK1 AS '' OVER
SUBT10 AS '' IN 10 T1 AS '' IN 34 T2 AS '' IN 49 T3 AS '' IN 75 T4 AS '' IN 91
-*
FOOTING
"OP0031(vk)"
ON TABLE PCHOLD FORMAT PDF
-*ON TABLE SET ONLINE-FMT PDF
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLE *
UNITS=IN,
SET PCHOLD-FMT=BINARY
PAGESIZE='LETTER',
LEFTMARGIN=0.2500000,
RIGHTMARGIN=0.2500000,
TOPMARGIN=0.2500000,
BOTTOMMARGIN=0.2500000,
SQUEEZE=OFF,
ORIENTATION=PORTRAIT,
WRAP=OFF,
$
TYPE=REPORT,FONT=COURIER NEW,SIZE=8,$
TYPE=HEADING,LINE=1,JUSTIFY=CENTER,FONT=TIMES NEW ROMAN,SIZE=9,STYLE=BOLD,$
TYPE=HEADING,LINE=2,JUSTIFY=CENTER,FONT=TIMES NEW ROMAN,SIZE=9,STYLE=BOLD,$
TYPE=HEADING,LINE=4,FONT=TIMES NEW ROMAN, SIZE=8,STYLE=ITALIC+BOLD+UNDERLINE,$
TYPE=FOOTING,SIZE=7,$
TYPE=REPORT,FIELD=TITLEA,STYLE=BOLD,$
TYPE=REPORT,FIELD=TITLEB,STYLE=BOLD,$
TYPE=REPORT,FIELD=TITLEC,STYLE=BOLD,$
TYPE=REPORT,FIELD=TITLED,STYLE=BOLD,$
TYPE=REPORT,FIELD=TITLEE,STYLE=BOLD,$
TYPE=REPORT,FIELD=TITLEF,STYLE=BOLD,$
TYPE=REPORT,FIELD=TITLEG,STYLE=BOLD,$
TYPE=REPORT,FIELD=TITLEH,STYLE=BOLD,$
TYPE=REPORT,FIELD=TITLEI,STYLE=BOLD,$
TYPE=REPORT,FIELD=SUBT18,STYLE=UNDERLINE,$
TYPE=REPORT,FIELD=SUBT19,STYLE=UNDERLINE,$
TYPE=REPORT,FIELD=SUBT20,STYLE=UNDERLINE,$
ENDSTYLE
END
October 16, 2007, 10:26 AM
vkrugmanWF version 523 and thanks for your help
October 16, 2007, 10:30 AM
Francis Mariani1) SET PCHOLD-FMT=BINARY is not WebFOCUS styling, therefore it should not be coded within the style-sheet
2) SET PCHOLD-FMT=BINARY is not valid WebFOCUS syntax - I've never seen this before
3) You already have ON TABLE PCHOLD FORMAT PDF - you should not be entering code to hold the report in another format.
October 16, 2007, 10:33 AM
Francis MarianiI don't know why the line of code gets generated. Could you rebuild the style-sheet using the GUI (which I assume how the report was built)?
October 16, 2007, 10:34 AM
PrarieAlso that line is within the Stylesheet. What is that line supposed to be doing?