>The problem happened while trying to update a table and the code, uses many select statements that involves joining three tables.
>
>What would be a possible fix for this? If I specify the MemLimit in config.fpw, would that help? What are the other things that I could specify in my Config file to resolve this?
>

What version of FoxPro or VFP is in use? The MEMLIMIT entry has no effect on VFP; you'll likely have to make adjustments in the virtual memory settings for the OS, or for the .EXE's PIF file, to work around this in VFP.