One array is considered one variable in VFP regardless of how many items it has. The max number of variables in VFP program is controlled by MVCOUNT setting in the CONFIG.FPW.
The size of the array is limited to 65,000 elements. You cannot store your table into array because it'll exceed the max array size.
>I have a program that reads a table and stores the result set in an array using the select ... into array command. That table is roughly 50000 x 10. I get VFP error 22, Too many variables. I am using VFP 7.0 SP1. This program is part of a larger architecture where data is being passed by array. Is there any way for VFP to handle a large array or is this a product limitation? Any help would be appreciated.
>
>Tom Paterno
--sb--