Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Simon Arnold
  Where is Simon Arnold?
 Halifax
 United Kingdom
 Simon Arnold
 To: Mike Dershowitz
  Where is Mike Dershowitz?
 Philadelphia
 Pennsylvania - United States
 Mike Dershowitz
 Tags
Subject: RE: "Too Many Variables" error
Thread ID: 537 Message ID: 541 # Views: 2 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Monday, June 04, 2001 3:49:21 PM         
   


> > > I am getting this error when executing a bunch of code. I have declared quite a few variables (maybe 50) but is there a place where I can reset that limit higher? If not, do I actually have to declare variables, and clear the ones from memory that I might be no longer using?
> >
> > Hi Mike,
> >
> > I think you have a line MVCOUNT=20 (or any other low number) in your
> > config.fpw file. Another cause could be a SELECT SQL INTO ARRAY ... -> more
> > than 65000 elements in the result array.
> >
> > --
> > Eric den Doop
> > www.foxite.com - The Home Of The Visual FoxPro Experts
>
> Eric:
>
> Thanks for your help thus far. It seems that I don't have a config.fpw file. Additionally, I tried setting this paramter in my program that is hvaing the issue, and I continue to get the error.
>
> Here's what I am setting: mvcount = 65000
>
> So, how do I create a configuration file? The most records that I want to keep in a table is like 20K. However, I have just over 60 variables that I am declaring, not includding about 20 arrays. Does the mvcount of 65000 include all records in all tables/cursor/arrays that are open, or is this a setting for just one table/cursor/array. Can I increase it?
>
> Thank you in advance.
>
> Mike
>

To create the config.fpw file use notepad of modi File in VFP, then make sure you save the file as Config.fpw.

MVCOUNT can only be set in the config file and nowhere else.

example config.fpw:-
MVCOUNT=5000
TMPFILES=C:\TEMP
PROGWORK=C:\TEMP
EDITWORK=C:\TEMP
SORTWORK=C:\TEMP
DATE=BRITISH

Records contained in tables are not classed as variables unless you issue a SCATTER MEMVAR to copy the data from the file to memory variables.

? Do you really need to create all these variables.

Simon Arnold
Westlake Computer Systems Ltd.
Halifax, UK.
simon.arnold@foxite.com

ENTIRE THREAD

"Too Many Variables" error Posted by Mike Dershowitz @ 6/4/2001 3:04:43 PM
RE: "Too Many Variables" error Posted by Eric den Doop @ 6/4/2001 3:14:57 PM
RE: "Too Many Variables" error Posted by Mike Dershowitz @ 6/4/2001 3:40:26 PM
RE: "Too Many Variables" error Posted by Simon Arnold @ 6/4/2001 3:49:21 PM
RE: "Too Many Variables" error Posted by Eric den Doop @ 6/4/2001 3:56:47 PM
RE: Posted by Mike Dershowitz @ 6/5/2001 8:51:51 AM
RE: Config.fpw Posted by Simon Arnold @ 6/8/2001 2:02:14 AM