>Hi All
>
>
>Ran into this error the other day. Help I blew the number of variables vfp maintains and that I can
>adjust the amount of variables with a configuration file using the MVCOUNT option to increase the
>number of variables foxpro maintains. I'm not sure how to use this option exactly.
>Does anybody have an example of a configuration file using MVCOUNT and what type of things
>contribute to this type error as in selecting data into arrays as apposed to selecting into a datafile ?
>
In CONFIG.FPW:
MVCOUNT=2048
The value can be anywhere between 128 and 65000, it defaults to 1024
An array uses 1 variable name, but it sometimes results in exhaustion of other limited resource sizes before the theoretical maximum allowed by MVCOUNT. In addition, arrays can have a maximum of 65000 elements per array, so if the number of colums * number of rows selected exceeds this number, the array formation will result in the error 'Too many variables' regardless of other variable assignments. Selecting into arrays where the number of elements is large is generally a bad idea; you can use a cursor in most cases.