>
>SELECT key1,key2 FROM lookup WHERE typename="ECO-STATUS" ORDER BY key2 INTO ARRAY thisform.aStatuscodes
>FOR EACH scode IN thisform.aStatuscodes
> scode = TRIM(scode)
>ENDFOR
>
>My expectation was that
scode would now be reflected back into the form's array property. I can see
scode changing each time, but when the loop is done, the array is unchanged.
>
>I know I how to re-write this using ALEN(), but could somebody explain why the FOR-EACH code is not working and how to use it to update the values in the array?
>
>Thanks to all...........Rich
It works as it should do.
You could use TRIM inside SELECT-SQL to get what you want.
Edward Pikman
Independent Consultant