Well did you try the old standby of using GoTo/Label instead of While/Endwh just to see if it will complete?
----- Original Message ----- From: <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Friday, August 10, 2012 10:16 AM Subject: [RBASE-L] - Cursor ideas? : This client has a big database, needs to get to a 64-bit. The .rb2 file is : usually 1.4 GB. However, they still have a major piece in DOS so we're : still at 32-bit. : : We haven't yet been able to successfully "convert" the one DOS piece to : windows. This is a commission program they run once a month (I did not write : this program nor design the database). The DOS program creates a temp : table, loads about 50K rows into it, then runs a cursor through every single row. : They typically copy the database to a local drive and run the program, : later just loading the data to the permanent table in the live database. The : cursor runs through hundreds of lines of code to figure out the commission : and even calls a couple other subroutines for certain situations. It takes : a few hours to run, but it works. : : In Windows I've done the same thing -- copy the database to a local drive, : step through the code. There are no errors generated, the code seems to : work perfectly fine in windows. But at some point maybe 2/3 of the way : through the cursors, the program will lock up. Never once have we gotten it to : complete. I took the subroutine code and put it right in the cursor so that : it wouldn't have to call other external programs. I changed it to be a : permanent table rather than a temp table. Nothing so far has made it go all the : way through. : : I'm sure some of this code is maybe inefficient or can be replaced with : some update commands up front that might make the code faster, but it probably : won't diminish the number of rows to cursor through. I've never seen so : much complicated machinations going on just to calculate a commission! I hope : I don't have to try to understand this code and come up with alternatives! : I'd like to just get the cursor to finish (admit it -- I'm lazy). : : Anyone have ideas or settings I can try to get this thing to get through : all rows? I have never before tried to run a cursor with this many rows! : : Karen : : --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
