[SOLVED] EXEC in maintain not returning all columns
Hi,
I call a fex from a maintain app using EXEC and placing the non formatted data into columns in a stack. The fex is very simple...
TABLE FILE FOW_VOUCHERS
SUM
CNT.HFCCID
BOOKAMT
VOUCHERAMT
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
This has worked fine, but today I was asked to change CNT.HFCCID to CNT.DST.HFCCID. Once I made this change the data for HFCCID stop populating the corresponding column in the stack. I've ran the fex to verify it is working, and it is. CNT.DST.HFCCID is returning a value but its not making it into maintain.
Any ideas why?This message has been edited. Last edited by: brjohnson,
Bryan Johnson WebFOCUS 7.7.03 Maintain Win 7 Excel, PDF, HTML
January 30, 2009, 01:48 PM
j.gross
You probably get two columns named HFCCID, which stack-processing cannot handle. For example:
TABLE FILE CAR
SUM SALES CNT.DST.CAR
ON TABLE HOLD
END
?FF HOLD
Result:
NUMBER OF RECORDS IN TABLE= 18 LINES= 1
(BEFORE DISTINCT TESTS)
FILENAME= HOLD
SALES E01 I6
CAR E02 I5
CAR E03 A16
That's with the default setting of HOLDLIST=ALL. Try adding ON TABLE SET HOLDLIST PRINTONLY to your TABLE ... PCHOLD code.
And you may as well drop all the print-formatting code: HEADING "" FOOTING "" ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT, $ ... from your TABLE request. It serves no purpose.
January 30, 2009, 02:12 PM
brjohnson
Spot on you nailed it. Thanks for help!!!
Bryan Johnson WebFOCUS 7.7.03 Maintain Win 7 Excel, PDF, HTML