I have a app that pulls some data out of an Oracle database.
Stores it locally then jiggles around with it - sending it to Excel - printing the spreadsheet then saving the worksheet. The problem is it crashes after doing n amount of the total it needs to do.
I have used SYS(1001) and SYS(1016) and cannot see the memory changing a greaat deal - I have 64 megs and when it last crashed the SYS(1016) was at 696044 (I was writing down the amount each time it processed a step).

Any ideas - is it the OLE? Is it a memory problem - sometimes it gets further through than other times. I used to pull the data out of the Oracle tbales as I needed it - now I have it all in local FoxPro tables.

TIA

Martin