not enough memory to complete this operation
I assume you are using the remote views or SQL Passthrough to connect to
the SQL Server data. Is this correct?
Before you connect or open any data, I would optimize the Visual FoxPro
memory buffers using the SYS(3050) function. You may need to alter the
number of bytes the buffer contains (try making it larger or smaller) until
you find the optimum performance setting. See 176483 PRB: Large Amounts of
RAM Seem to Process Data Slowly
Before and after you perform each remote view or SQL PassThrough command,
use the SYS(1104) function to clear VFP memory. See 269284 INFO:
Undocumented Function SYS(1104)
I hope this helps.
This posting is provided "AS IS" with no warranties, and confers no rights.
Microsoft FoxPro Technical Support
*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
Purchase VFP8 here:
Keep an eye on the product lifecycle for Visual FoxPro here:
- VFP5 Mainstream Support retires June 30th, 2003
- VFP6 Mainstream Support retires Sep. 30th, 2003
>I am running a fox app through an sql server conncetion.
>With heavy processing on a foxpro cursor I recieve the
>message 'There is not enough memory to complete this
>operation', however if the volume of data is reduced then
>subsequent processing is fine. I have increased the page
>file but one thing I have noticed that at certain point
>memory is absorbed continually and performance hangs, I
>have tried to release variables and close open cursors but
>the virtual memory will not release. Has any one got any