Information générale
Catégorie:
Codage, syntaxe et commandes
>>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.
Thanks Ed,
As it turns out, the select statement into the array had a problem anyway, but what's weird is that the datafile
had only 4100 records and 20 fields but was using a Grouping option on a field what wasn't setup (blank). Really
appreciate your time.
Thanks again,
Don
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement