Re: Insufficient memory for this operation.

Dennis wrote:
> We are VERY interested in this since we get this error too.

One thing I did was go to the Appendices of my book on dBASE (2nd 
Edition) and play with the settings for the BDE Administrator. I don't 
know if this has solved the issues for the client yet. I've set 
everything to the suggested settings on page 754.

Then I used the code in the dUFLP to generate a program he is already 
running that modifies the settings on his end ... BDEReg_SystemInit.prg 
is what is generated, it's generated from: :dUFLP:BDERegistrySettings.wfm

I sent him the .pro and asked him to put it in place of the existing 
one. When he starts the app there is code that checks for one of the 
settings, and if not correct it runs the program BDEReg_SystemInit.prg ...

// Make sure BDE settings are good ...
// --- Instantiate registry object:
// load the registry program
set procedure to :samples:registry.prg additive
#include <winreg.h>
#define BDE_REG_KEY "SOFTWARE\Borland\Database Engine"
oReg = new Registry(HKEY_LOCAL_MACHINE, ;
                     BDE_REG_KEY + ;
                     "\Settings\SYSTEM\INIT")
cMF = oReg.queryValue("MAXFILEHANDLES")

if cMF # "4096" // this hasn't been set properly:
    do BDEReg_dBASE
    do BDEReg_SystemInit
    // this will restart the program when run
endif


Ken



-- 
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase/dBASEBooks.htm

We are VERY interested in this since we get this error too.
Dennis
"Ken Mayer [dBVIPS]" <dbase@_nospam_goldenstag.net> wrote in
message 
news:zUxscRjYIHA.1092@news-server...
> My main client has run into something I am not duplicating ...
>
> The statement causing it is:
>
>          form.Daily3.rowset.save()
>
> So it's literally just saving a rowset. I have the same table open three
> times (due to the weirdness of the data design, which is an old
> annoyance I don't want to get into here).
>
> The error dialog is attached, but it's literally a Database Engine Error.
>
> Any suggestions? I've asked him to let me know how much RAM is on the
> machine in question, and what the virtual memory settings are ...
>
> (This application is making me a bit crazy, but that's another story ...)
>
> Ken
>
>
> -- 
> /(Opinions expressed are purely my own, not those of dataBased
> Intelligence, Inc.)/
>
> *Ken Mayer* [dBVIPS]
> /Golden Stag Productions/
> dBASE at goldenstag dot net
> http://www.goldenstag.net/GSP
> http://www.goldenstag.net/dbase/dBASEBooks.htm
> http://www.goldenstag.net/dbase
>
> 

In article <F6bIPmpYIHA.1236@news-server>, dbase@_nospam_goldenstag.net 
says...
> Dennis wrote:
> > We are VERY interested in this since we get this error too.
> 
> One thing I did was go to the Appendices of my book on dBASE (2nd 
> Edition) and play with the settings for the BDE Administrator. I don't 
> know if this has solved the issues for the client yet. I've set 
> everything to the suggested settings on page 754.
> 
> Then I used the code in the dUFLP to generate a program he is already 
> running that modifies the settings on his end ... BDEReg_SystemInit.prg 
> is what is generated, it's generated from: :dUFLP:BDERegistrySettings.wfm
> 
> I sent him the .pro and asked him to put it in place of the existing 
> one. When he starts the app there is code that checks for one of the 
> settings, and if not correct it runs the program BDEReg_SystemInit.prg ...
> 
<snipped>
> 
> 
> Ken


Ken,

Ronnie MacGregor has a class that does that and covers all the settings.

-- 
Geoff Wass [dBVIPS]
Montréal, Québec, Canada

.|.|.|        dBASE info at http://geocities.com/geoff_wass       |.|.|.
.|.|.| ---------------------------------------------------------- |.|.|.