Focal Point
[SOLVED] Multiple versions of date fields in hold file

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

January 15, 2020, 10:20 AM
DWaybright
[SOLVED] Multiple versions of date fields in hold file
I am using SQL pass-through to create a hold file. In my TABLE FILE statement to put the fields into the hold file, I add formatting to the date fields (Month_End_Date/MDYY). This causes two copies of that field to appear in the master file for the hold file, both with the same name but each has a different format:
     
FIELDNAME=Month_End_Date, ALIAS=E22, USAGE=YYMD,
      MISSING=ON, $
FIELDNAME=Month_End_Date, ALIAS=E23, USAGE=MDYY,
      MISSING=ON, $ 

Only the first one shows up in the field listing in InfoAssist. If I try to remove the first one I get an error and the master file gets corrupted.
Anyone else run into this? I can get around it with changing the format of the field prior to the TABLE FILE statement, but it seems silly to have to add lines of code instead of just a few characters.

This message has been edited. Last edited by: DWaybright,


WebFOCUS 8.2.03 (production), 8.2.06 (testing)
AppStudio, InfoAssist
Windows, All Outputs
January 15, 2020, 10:41 AM
jfr99
Try putting this line ...
ON TABLE SET HOLDLIST PRINTONLY
before your ON TABLE HOLD line


WebFocus 8.201M, Windows, App Studio
January 15, 2020, 11:17 AM
DWaybright
quote:
ON TABLE SET HOLDLIST PRINTONLY

That worked! Thank you so much!
Big Grin


WebFOCUS 8.2.03 (production), 8.2.06 (testing)
AppStudio, InfoAssist
Windows, All Outputs