I just found that if I use a loop to read data from a multi-row file, I can't use -RUN in it. Otherwise the value of the -READ always stay the same.

Example 1:

quote:

TABLE FILE CAR
PRINT MODEL
WHERE COUNTRY EQ 'ENGLAND'
ON TABLE HOLD AS TEMP_CAR FORMAT ALPHA
END


-SET &TIMES=&LINES;

-REPEAT :END_LOOP &TIMES TIMES

-READ TEMP_CAR &MODEL.A20.;
-TYPE &MODEL

-:END_LOOP

The result is correct as

quote:

V12XKE AUTO
XJ12L AUTO
INTERCEPTOR III
TR7

Example 2:

quote:

TABLE FILE CAR
PRINT MODEL
WHERE COUNTRY EQ 'ENGLAND'
ON TABLE HOLD AS TEMP_CAR FORMAT ALPHA
END


-SET &TIMES=&LINES;

-REPEAT :END_LOOP &TIMES TIMES

-READ TEMP_CAR &MODEL.A20.;
-TYPE &MODEL
-RUN
-:END_LOOP

The loop still runs but the -READ result is always V12XKE AUTO

quote:

V12XKE AUTO
V12XKE AUTO
V12XKE AUTO
V12XKE AUTO

Why is that?

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

As the manual states, to read a multi-row file, either use -READFILE(available in 7.x.x release, don't know which one)
or
-READ FILENAME NOCLOSE &VAR1.A/In.

EDIT:
And, there is no ; at the end of the -READ line

This message has been edited. Last edited by: Tom Flynn,

quote:

Originally posted by Tom Flynn:
As the manual states, to read a multi-row file, either use -READFILE(available in 7.x.x release, don't know which one)
or
-READ FILENAME NOCLOSE &VAR1.A/I/n.

Yes it works.

Good to know that. I did not use NOCLOSE but it still works, until I got this problem.

Thanks Tom!

FYI

-RUN will close open files, unless you have the NOCLOSE option