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: Config.fpw
Thread ID: 537 Message ID: 638 # Views: 1 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Friday, June 08, 2001 2:02:14 AM         
   


> > > > > 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
>
> 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
> > >
> > > 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

This file is usually created in the source directory of your application.
There are a number of ways you can make your application use this config file :-

1. Include the file into the Project.
2. Use the AutoExec SET variable: SET FOXPROWCFG=c:\mypath\myconfig.fpw
3. You can specify the -Cc:\mypath\myconfig.fpw on the command line of you EXE file.

For more detailed information on this I would suggest you look at the Configuring Visual FoxPro section in the HELP, this can be found under: Getting Started, Installation Guide.

Hope this Helps.
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