>>Does anyone have any suggestions in addition to Terry's? I don't think MVCOUNT will help. I suspect that the problem is in the code itself. I believe this code worked once in VFP8, but now I'm running from VFP9 and after ~ 1 hour of running it goes out of memory. Though may be it was because I didn't restart my computer for months. Today I re-started it, so I may keep my fingers crossed and try to run it again. It's extremely important for me to finish it successfully, because we're "going live" from January 1st and the files must be created for all records.
>>
>>Thanks a lot in advance.
>
>Look in VFP Help at SYS(1104) (Purge Memory Buffer) and SYS(3050) (Set buffer memory size). If the operation is running in the background, the buffer size can be only 25% of the foreground buffer.
I'll try that, thanks again.
If it's not broken, fix it until it is.
My Blog