I have a PRINT field that I convert from a D20.2 to an I3 that gets put in a hold file, XFOCUS or FOCUS format. When I use the field as a BY field from the hold file the formatting reverts back to its original D20.2 and I can't seem to reformat it. Any idea how to go about this and why this is happening?
PRINT
HIGH_SCHOOL_RANK/I3
....
ON TABLE HOLD AS INITHLD FORMAT XFOCUS INDEX 'PIDM_KEY'
....
JOIN.....
BY HIGH_SCHOOL_RANK AS 'HS Rank'
ThanksThis message has been edited. Last edited by: Trudy,
WF8 Windows
August 22, 2019, 01:24 PM
MartinY
Look at this
TABLE FILE CAR
BY COUNTRY/A50V
ON TABLE HOLD AS TMP FORMAT FOCUS
END
Since you have not renamed the redefined field, you have twice the same field name in your master file and it seems that it's the old one that is used in your subsequent TABLE FILE
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
August 22, 2019, 01:30 PM
Tom Flynn
TABLE FILE CAR BY COUNTRY/A50V ON TABLE HOLD AS TMP FORMAT FOCUS END -RUN ?FF TMP -EXIT
Results:
FILENAME= TMP COUNTRY E01 A50V COUNTRY E02 A10
So, Add: SET HOLDLIST=PRINTONLY TABLE FILE CAR BY COUNTRY/A50V ON TABLE HOLD AS TMP FORMAT FOCUS END -RUN ?FF TMP -EXIT