I answered this question for someone else here the other day. Although my solution didn't help him, it sounds like it will for your situation. See message id 702501.

>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?
>
>Thanks
>
>Ria