Has anyone seen a WHERE statement like this? In this excerpt are the only 2 places "LIST" is used in this focexec. Is the .LIST suffix documented?

TABLE FILE WHATEVER
LIST A
     B
     C
ON TABLE HOLD AS HOLDLST1
END

-REPEAT NEXTLST1 FOR &LST1 FROM 1 TO &TOT1

TABLE FILE HOLDLST1
PRINT A
      B
      C
WHERE HOLDLST1.LIST EQ &LST1
ON TABLE HOLD FORMAT ALPHA
END
-RUN

-READ HOLD &A.A3. &MCNO.A3. &B.A3. &C.A1. 

...

-NEXTLST1

...

 

Thanks,

John

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

The .LIST in this case indicates a field name (LIST) in file HOLDLST1. It is not a suffix. Just like CAR.COUNTRY. LIST as the verb creates an I5 field in the hold file called LIST.

Geez! Now I see it. It's just a qualified field name. I knew the LIST verb creates a numeric field called LIST (learned that over 20 years ago). I couldn't switch gears from tracing all the variables with suffixes all over the rest of the code.

Thank you,

John