Insufficient memory for this operation

I was just doing a test of one of our Internet applications and when I press 
the submit button at the bottom of the first screen I get the following 
error.
Program Alert


--------------------------------------------------------------------------------


04/10/2008 15:34:34.14
An error occurred in: 
D:\htdocs\ubquotesonline\public\cgi-bin\coverages_new.exe

Error Code: 239

Database Engine Error: Insufficient memory for this operation.

Source File: D:\htdocs\ubquotesonline\public\cgi-bin\coverages_new.prg

Routine: coverages_new

Line: 319


Line 319 is the "active = true" line of a query.  The table is not
corrupt 
and can be opened manually with no problem. Here is a cut and paste leading 
up to line 319.

        // open Users.dbf and gather producer information
         qUsers = new query()
         qUsers.database := d
         qUsers.sql := 'select * from "users.dbf"'
         qUsers.active  := true

No files are locked on the server; and, there is no indication of what else 
might be happening.  Does anyone have any insight into this?



-- 
Dan Anderson
UBI Processing Dept.
andersond@ubinc.com
800-444-4824 ext 101 

Dan 
 I had a similar problem and think it might be related to the reply:
Geff Wass made to you on your March  25 post:
"A guess: the table is not actually open exclusively (but it is open). 
Remember, dB+ will still USE a table even if it is already open 
elsewhere. Alternatively, the table is corrupt.

If I recall correctly, you are using the latest dBASE PLUS, so you could 
use the OOP techniques (the DATABASE.emptyTable() ). Even with the old 
commands, ZAP does the same thing as DELETE ALL with PACK."

I came up with this quick test:
 In the IDE you can do a quick test to determine if the table is open somewhere
else.
in the command window type 
close data
select 1
use mytable exclusive
// at the bottom you  should see
mytable.dbf  Exclusive
select 2
use mytable exclusive
// at the bottom you should see
mytable.dbf   //NO Exclusive
select 1
// at the bottom you should see
mytable.dbf   Exclusive
close data
this proves that Dbase tests and knows the table cannot be opened exclusivle but
opens it anyway.
I talked to someone at Dbase a while ago and asked if there was a way to test
this entryfield (textlable???) 's value.
They said they would pass my request on but I never got a reply as how it could
be done.
Anyone out there with a test for this?
I also am not sure this would work in deployment but if I remember correctly if
you set TALK off (it displays to the command window that is not in runtime) it
speeds up some prcesses (Thanks Gary White on this) so who knows?
John Jay
Charter member 502

In article <kHQfIW0mIHA.320@news-server>, andersond@ubinc.com says...
> I was just doing a test of one of our Internet applications and when I
press 
> the submit button at the bottom of the first screen I get the following 
> error.
> Program Alert
> 
> 
>
--------------------------------------------------------------------------------

> 
> 04/10/2008 15:34:34.14
> An error occurred in: 
> D:\htdocs\ubquotesonline\public\cgi-bin\coverages_new.exe
> 
> Error Code: 239
> 
> Database Engine Error: Insufficient memory for this operation.
> 
> Source File: D:\htdocs\ubquotesonline\public\cgi-bin\coverages_new.prg
> 
> Routine: coverages_new
> 
> Line: 319
> 
> 
> Line 319 is the "active = true" line of a query.  The table is
not corrupt 
> and can be opened manually with no problem. Here is a cut and paste leading

> up to line 319.
> 
>         // open Users.dbf and gather producer information
>          qUsers = new query()
>          qUsers.database := d
>          qUsers.sql := 'select * from "users.dbf"'
>          qUsers.active  := true
> 
> No files are locked on the server; and, there is no indication of what else

> might be happening.  Does anyone have any insight into this?
> 

Dan,

Check your BDE settings. They may be too small.

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

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