You are chewing up memory inside the while loop. You know this has reared its ugly head many times over the years, so the quick way to make the routine finish is to use GoTo. You can solve the mystery of memory leak by tearing apart the stuff that runs within the loop at your descretion.
----- Original Message ----- From: <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Friday, August 10, 2012 3:58 PM Subject: [RBASE-L] - Re: Cursor ideas? Alastair: we tried putting a disconnect and reconnect at the beginning of running the program and that didn't help. I suppose I could change it to use a permanent table rather than temp, running maybe 15K rows of the cursor, jump out of the cursor, do a disconnect and reconnect and then jump back into the cursor using a flag column to keep track of what I've done and what I haven't yet. Haven't tried that. That might be a quicker test than converting to a GoTo. Keep the good ideas coming! Karen In a message dated 8/10/2012 12:35:33 PM Central Daylight Time, [email protected] writes: > On the other hand, if you have to go this route, you might find that just > disconnecting and reconnecting will do the trick – if so it’s easy to > automate... > > Regards, > Alastair. > > >
