Good Afternoon,

Thought I understood this, apparently not.

-DEFAULTH &Test=0;
-DEFAULTH &&Test=0;
TABLE FILE HOLD_TMP
BY
HOLD_TMP.TestID AS 'Test'
WHERE ( ROWCNT EQ 1 );
ON TABLE HOLD AS HOLD_TMP_A FORMAT ALPHA
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE SET HTMLEMBEDIMG OFF
ON TABLE SET HTMLCSS OFF
END
-RUN
-READ HOLD_TMP_A
-RUN
-CLOSE HOLD_TMP_A
-SET &&Test=&Test;
-TYPE &&Test

HOLD_TMP is a table with structure (TestID guid, ROWCNT int). In this example I want to pull the first row and put the value in a variable, (this will actually be placed in a loop to iterate over the whole table, performing quite a bit of business logic on each value), but instead of a guid I am getting 0. I have this same idea working in another procedure hence the "Thought I understood this, apparently not." Is there something obvious I'm missing or what things should I start looking at?

Thanks!

This message has been edited. Last edited by: FP Mod Chuck,

Try this

TABLE FILE HOLD_TMP
BY TESTID
WHERE ROWCNT EQ 1;
ON TABLE HOLD AS HOLD_TMP_A
END
-RUN
-READFILE HOLD_TMP_A
-RUN
-DEFAULTH &TESTID = 0
-DEFAULTH &&TEST = 0
-SET &&TEST=&TESTID;
-TYPE TEST=&&TEST

When you use -READ you must specify the field name.format. (-READ HOLD_TMP_A &TESTID.I5.) which is not the case using -READFILE and much more simple to use.

Worked, thanks!