>>>>Hi
>>>>
>>>>Using VFP8.
>>>>Select into array can only accept 24 columns. is that right?
>>>>
>>>>I am getting "too many variables" error when I select more than 24 column into the array.
>>>>is there awork around it?
>>>>
>>>>Mo
>>>
>>>Arrays are limited to approximately 16k of elements. The problem is not the number of columns, but the number of rows. How many records are being selected?
>>
>>It's 65,000 elements, not 16K. This restriction has been entirely lifted in VFP9.
>>
>
>VFP9 array size is bounded to 67M = 2^(30-4)

Well of course there is an actual limit. Just not one that I think any kind of "currently" reasonable code would ever encounter. That may very well change in the future.

And are you sure of your upper limit? I thought it was limited by available memory. I couldn't make an array of 50M (2x25,000,000)elements as I had insufficient memory on a machine with 512MB, but I usually have many apps currently running.