>I have a record with a FIELD
>savearray CHAR 36
>
>I have a 2-dimensional array that I want to save into the record FIELD
>I can have to up 36 "Y"s stored in my array based upon conditions.
>I set up the array in the Init of my Form.
>PUBLIC myarray
>DIMENSION myarray (6,6)
>
>I plug values into the array as follows:
>myarray (1,1) = "Y"
>myarray (2,4) = "Y"
>myarray (5,6) = "Y"
>and so on...
>
>But when I do the command -
>REPLACE FROM ARRAY myarray FIELDS savearray
>only the first Y gets saved into the record.
>I think it is the myarray(1,1) that gets saved. The others don't appear in the saved record.
>
>Can't the REPLACE FROM ARRAY command handle 2-dimensional arrays? Or what am I doing wrong? Help please. Thanks.
>
REPLACE FROM ARRAY replaces each field in the list with the specified value - it doesn't concatenante the values in an array together to build a field for you. you'd need to build a single string from your array and use a simple REPLACE statement to do what you want to do.