Answered

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.

 

0
1 comment
Avatar
Joseph Hamdan

Hi Stephen,

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

@ETA_Fund_IC.rowsCount-1

Regards,

Subject7 Team

0
Comment actions Permalink

Please sign in to leave a comment.