SET_LIST question

Hello, for a SET_LIST command that generates a SQL list of records; variable @ETA_Fund_IC.rowsCount is showing 10 rows of records (0-9).

I had a LOOP command using this @ETA_Fund_IC.rowsCount variable to get each record in a @counter variable, and used in in @ETA_Fund_IC[@counter][1]; but it continues past the 9th variable to get @ETA_Fund_IC[10][1] .


How do I get it to stop at the last variable, even though the row count is correct? Thanks.


1 comment
Joseph Hamdan

Hi Stephen,

Can you please add -1 so that loop would iterate in the list only? The End will look like this:



Subject7 Team

Comment actions Permalink

Please sign in to leave a comment.