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!

Without 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.

this 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

WF version 523 and thanks for your help

1) 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.

I 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)?

Also that line is within the Stylesheet. What is that line supposed to be doing?

quote:

SET PCHOLD-FMT=BINARY

I have no idea what and how this line is doing!
I've just reran my code by deleting this line and it worked. It WORKS if I urn it from developer studio. As soon as I run a report from an application that SET PCHOLD-FMT=BINARY line returnes back to the same place! Do you think I need to recode the style-sheet? Thank you to all!

quote:

SET PCHOLD-FMT=BINARY

This looks like a bug. You will have to login to Tech Support to see this document, but it appears there's a patch to Dev Studio to correct the problem.
Developer Studio Upgrade/Service Pack 5.2.8

I searched for "SET PCHOLD-FMT=BINARY" (with the double-quotes) in Tech Support.

THANKS, Francis! I l'll take a look!