>>Hi
>>
>>We are running VFP6 SP4 on a PIII 650 mhz with 192 Ram, We receive messages
>>"Not Enough MEMORY to complete this operation", The system works fine with other heavier applications than VFP, Do any one can help me with some settings to solve it?
>>
>
>Not without more data about what actually causes the crash. The single most likely thing to cause the problem is a poorly constructed SQL Query that creates a Cartesian join of several tables, resulting in a single intermediary result that's bigger than the total amount of virtual memory available to VFP. Fixing the query is likely to make the problem go away.
Ed,
hehe...
I have the following program that is automatically loading everytime I launch VFP. I am getting the same error. I am using a PIII 733 with 256 mb ram. A further side affect is that it is taking a LONG time for VFP to load, and the hard disk seems to get hit pretty hard. Any ideas?
As a sidebar, I don't normally hardcode constants like this. I wrote this program a long time ago, and haven't had time to rewrite it in a more flexible manner.
local i
dimension aMemoryKiller[2048]
for i=1 to 2048
aMemoryKiller[i] = createObject("memoryKiller")
next i
define class memoryKiller as custom
dimension aBunchOfSpace[1024]
procedure init
local i
for i = 1 to 1024
this.aBunchofSpace[i] = space(16000)
next i
endproc
enddefine
I just couldn't resist...no intent to offend the original poster...
Steve Gibson