>>>I have a code table that has Type_Code and Code fields.
>>>I am trying to copy to an array all the Type_Code = to "PE" and I don't know why but it only copies the first record to the array. Here is my code:
>>>
>>>use codes
>>>set order to Type_Code
>>>count for Type_Code = "PE" TO ctn
>>>DIMENSION aCode(ctn)
>>>COPY TO ARRAY aCode FIELDS Code FOR Type_Code = "PE"
>>>DISPLAY MEMORY LIKE Ape
>>>
>>>Thanks for your help
>>
>>Ray, remove the line "DIMENSION aCode(ctn)" That pre-sets the size of the array. Copy to Array will automatically initialize and size the array correctly IF the array doesn't exist.
>>
>>HTH
>>Barbara
>
>Still, why it doesn't work? I exclude the case when there's only PE record. :)
>
>Vlad
Vlad, check out the HELP for Copy to Array.
** From HELP
If you specify a one-dimensional array, the first field of a record is stored to the first element of the array, the second field is stored to the second element of the array, and so on. If the one-dimensional array has more elements than the table has fields, any remaining elements remain unchanged. If the array has fewer elements than the table has fields, any remaining fields are ignored.
Since Ray had initialized a one-dimension array, this action took over.
Barbara