Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Mike Dershowitz
  Where is Mike Dershowitz?
 Philadelphia
 Pennsylvania - United States
 Mike Dershowitz
 Tags
Subject: Additional help with Config
Thread ID: 556 Message ID: 556 # Views: 13 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Tuesday, June 05, 2001 9:42:16 AM         
   


***************See bottom!
> > > > 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.
>

Simon:

Thank you for your help thus far. do you know where I need to save this file in order for it to work? Also, do I have to tell FOXpro that I am now using a config file. Or, can this be controlled through the existing user interface somehow?

Mike


ENTIRE THREAD

Additional help with Config Posted by Mike Dershowitz @ 6/5/2001 9:42:16 AM
RE: Additional help with Config Posted by Eric den Doop @ 6/5/2001 10:00:02 AM