Focal Point
[SOLVED] EXEC in maintain not returning all columns

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

January 30, 2009, 12:23 PM
brjohnson
[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