David,
Check to see if SYS(3055) helps.
>My client runs a Commission Report and it crashes with a "Not Enough Memory" condition on an SQL statement that uses some pretty big files with pretty big indexes. It crashes on my PC too. However, why I delivered a defective feature to them is that I tested this feature from the command window and had to test it so often for so long that I plain forgot to test it from inside the app.