Not enough memory to complete operation 
Author Message
 Not enough memory to complete operation

I have the following query in VFP 5.0 where md0011 , md0015 ,
'UNS_4_19_120_1_0R.dbf' are 3 tables :

Select md0011.NATION as Row1,md0011.REGION as Row2,md0011.DIST as
Row3,md0011.TERR as Row4,md0011.PROD as
Row5,f0015.NATION,f0015.REGION,f0015.FF,f0015.MRKT,f0015.PROD,f0015. CQTRSHR
*1 As  CQTRSHR ,f0015. PQTRSHR *1 As  PQTRSHR ,f0015. SHRGROWTH *1 As
SHRGROWTH  From (md0011 inner Join md0015 on
md0011.REGION+md0011.FF+md0011.MRKT+md0011.PROD =
md0015.REGION+md0015.FF+md0015.MRKT+md0015.PROD  ) left join
'UNS_4_19_120_1_0R.dbf' f0015 on  f0015.REGION + f0015.FF + f0015.MRKT +
f0015.PROD =  md0015.REGION + md0015.FF + md0015.MRKT + md0015.PROD and
f0015.Row1 + f0015.Row2  + f0015.Row3 + f0015.Row4 = md0011.NATION +
md0011.REGION + md0011.DIST + md0011.TERR OR f0015.Row4 IS NULL into Table
UNS_5_19_120_1_0R

When executing this query under NT 4.0 , i get a "Not enough memory to
complete this operation" error message. However it seems to run fine on 95
 Strange!!!! If anything, I would have expected the other way around)

However if I remove the " OR f0015.Row4 IS NULL " clause at the end, it
works OK.

Any body seen anything like this...

Thanks

Rajesh




Tue, 09 Jan 2001 03:00:00 GMT  
 Not enough memory to complete operation
I know VFP5.0 has diiferent memory requirements in NT and 95 due to the way
each operating system distributes resources.  Use ? SYS(3015,1) to see how
much foreground memory is available.  This is not a FoxPro issue but a
Windows issue.

Don Stanley
Switchless Reseller Services

Quote:

>I have the following query in VFP 5.0 where md0011 , md0015 ,
>'UNS_4_19_120_1_0R.dbf' are 3 tables :

>Select md0011.NATION as Row1,md0011.REGION as Row2,md0011.DIST as

>When executing this query under NT 4.0 , i get a "Not enough memory to
>complete this operation" error message. However it seems to run fine on 95
> Strange!!!! If anything, I would have expected the other way around)

>However if I remove the " OR f0015.Row4 IS NULL " clause at the end, it
>works OK.



Sat, 13 Jan 2001 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. error - There is not enough memory to complete operation

2. Not enough memory to complete operation...

3. VFP7 will not open (There is not enough memory to complete this operation)

4. not enough memory to complete this operation

5. Not enough memory to complete this operation - vfp 3.0

6. There is not enough memory to complete this operation

7. Not enough memory to complete this task

8. VFP 3.0 - Not enough memory for this operation!?

9. Not enough memory error message - but there is plenty of memory

10. "There is not enough memory to complete this operation"

11. "There is not enough memory to complete this operation"

12. FPW2.5: "not enough memory"

 

 
Powered by phpBB® Forum Software