Focal Point
(SOLVED)Read Multiple Records from SAVE File

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

May 31, 2019, 01:17 PM
evan.brown
(SOLVED)Read Multiple Records from SAVE File
Here's a snippet of code that runs correctly in 8008 but not in my test 8204 environment. Any ideas as to what I need to do differently, aside from doing this in several steps? It does work fine when only using one field. Thanks

  
-SET &ECHO=ALL;

 TABLE FILE CAR
 SUM
 CNT.COUNTRY
 CNT.MODEL
 ON TABLE SET HOLDLIST PRINTONLY
 ON TABLE SAVE
 END
-*
-RUN
-READ SAVE &COUNTRY.5.&MODEL.5.
-RUN
TYPE &COUNTRY &MODEL

This message has been edited. Last edited by: evan.brown,


WF 8.0.08 (Prod); WF 8.2.06 (Dev)
May 31, 2019, 01:32 PM
FP Mod Chuck
Evan

Code tightening must have gotten you. This works


TABLE FILE CAR
SUM
CNT.COUNTRY
CNT.MODEL
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SAVE
END
-*
-RUN
-READ SAVE &COUNTRY.A5. &MODEL.A5.
-RUN
-TYPE &COUNTRY &MODEL



Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
May 31, 2019, 01:41 PM
evan.brown
quote:

Code tightening must have gotten you. This works


Boy, I had to look really hard for the difference. One space does make all the difference. Thanks


WF 8.0.08 (Prod); WF 8.2.06 (Dev)
May 31, 2019, 03:11 PM
MartinY
Try this instead, won't have to botter with "spaces" :-)
TABLE FILE CAR
 SUM
 CNT.COUNTRY
 CNT.MODEL
 ON TABLE SET HOLDLIST PRINTONLY
 ON TABLE HOLD
 END
-RUN
-READFILE HOLD
-RUN
-TYPE &COUNTRY &MODEL



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
May 31, 2019, 03:17 PM
evan.brown
Yes, thank you. I was just discussing that here at the office after I posted. I like this method Smiler


WF 8.0.08 (Prod); WF 8.2.06 (Dev)