The maximum number of elements you can have in an array is 65,000. You chould probably use a cursor instead.
>Does the array has limit? I got a error msg "too many variables" from my program. I checked by debugger. The error msg warn me at the command "COPY TO ARRAY arr". At the moment, the array lenght was 64998. Then, I tried to do it in vfp command window. I got the same msg.
>
>Does 64998 is the max lenght of array? How can I extend it? If I can't use array, will hard to code my program.
>
>Any idea?
>
>Sunny