WHILE has an effect only within a WHILE loop, and even in many WHILE loops, you won't notice a difference in whether it is on or off. I agree with Karen. When you have a loop that is too slow, then it is time to use WHILEOPT ON. Be sure all variables referenced inside the loop are declared outside the WHILE loop with SET VAR statements, that you never try to change the data type of an existing variable on the fly, and then turn WHILEOPT ON before the loop, and off again after the loop.
Bill On Thu, Jan 22, 2009 at 10:53 AM, <[email protected]> wrote: > We don't take "surveys" on this list, but if we did, I'll bet that over 90% > of programmers set whileopt off for their entire app. It was introduced > way back in some DOS version when code speed was a huge issue. Whileopt ON > made the code run faster (supposedly) but along with it came some stringent > coding "rules" that you had to follow or else you ran into these memory > issues. >
