Focal Point
changing read variable

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

February 01, 2007, 03:54 PM
.eric
changing read variable
I am trying to run a table request into a save file and read the value in the save file into an &VAR via loop, my question is how can I change the &VAR to read into &VAR1, &VAR2, &VAR3, ect depending on the number of the count.

Here is an example of what I'm trying to accomplish:

DEFINE FILE CAR
CNTR/I2 WITH MODEL = CNTR + 1;
END

TABLE FILE CAR
BY CNTR
BY MODEL
ON TABLE HOLD AS MODEL
END

-RUN

-SET &ENDCNT = &LINES;
-SET &LOOPCNTR = 1;
-REPEAT ENDREPEAT &ENDCNT TIMES
TABLE FILE MODEL
PRINT MODEL
WHERE CNTR EQ '&LOOPCNTR'
ON TABLE SAVE AS SAVEMODEL
END
-RUN
-READ SAVEMODEL, &VAR
-SET &LOOPCNTR = &LOOPCNTR + 1;
-ENDREPEAT

Eric


dev: WF 7.6.5 w/IIS + Tomcat

prod: WF 7.6.5 w/IIS + Tomcat
February 01, 2007, 04:18 PM
Francis Mariani
This may do the job:

-SET &ECHO=ALL;
SET HOLDFORMAT=ALPHA
-RUN

TABLE FILE CAR
SUM
MODEL
BY MODEL NOPRINT
ON TABLE HOLD AS HMODEL
END
-RUN

-SET &MODEL_COUNT = &LINES;

-REPEAT ENDREP1 FOR &N FROM 1 TO &MODEL_COUNT STEP 1;

-READ HMODEL &MODEL.&N.A24

-ENDREP1

-? &MODEL



Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 01, 2007, 04:31 PM
.eric
That's exactly what I needed, I also never even knew about the -? either.

Thanks!

Eric


dev: WF 7.6.5 w/IIS + Tomcat

prod: WF 7.6.5 w/IIS + Tomcat