"Too Many Variables" Error

[Shanachie]

I am suddenly getting a "Too Many Variables" error in a program that's been running without problems for six months. No changes at all have been made since January.

What would cause this to blow up now? The compile time message shows 139 symbols, which doesn't seem like a whole lot. The Help file doesn't.


TIA,
Shanachie

 

[jimstarr]

This error message can be misleading. It can occur when a SELECT INTO ARRAY yields a tally of > 65000. Perhaps your tables have grown enough to exceed this limit.

Jim

 

[csr]

Well, if no changes have been made to the program ...

Then the problem lies within the environment or the data.

I would vote for data.

This sounds like an array has been building in size over time due to an increase in data. Remember, each array element counts toward that memory variable count.



Don

 

[craigsboyd]

Try adjusting the setting for MVCOUNT in your config.fpw...

From the VFP Helpfile:

MVCOUNT
Sets the maximum number of variables that Visual FoxPro can maintain. This value can range from 128 to 65,000; default is 1024.

Slighthaze = NULL

[ul][li]FAQ184-2483
An excellent guide to getting a fast and accurate response to your questions in this forum.[/li][/ul]

 

[Shanachie]

Thanks to jimstarr and csr! They both were right. An array being SELECTed just got too big. I rewrote that logic using another approach and it works just fine.

Thanks Again!
Shanachie