Jan,
The optimization can help speed up performance, for example, in a WHILE loop. However, most computers are fast enough that I can't tell the difference in speed between an optimized loop and one that's not.
The biggest advantage of a one-SET-VAR-per-line style of programming is ease of debugging. If you string together 50 variables in one long command with plus signs and commas, and one of those variable names happens to become a reserved word, when it blows up someday, you will get a SYNTAX error. Knowing what needs fixing is a lot easier if there's only one variable name on the line that drove the error in TRACE.
Bill
Jan Johansen wrote:
Razzak recently posted this snippet.
06� If you issue multiple SET VARIABLE commands on a single command line, those variables will not be optimized. If you want to increase the speed for that loop, put those SET VARIABLE commands on separate lines.
I have set variables on a single command line for some time now. What benefit to having the variables optimized?
Jan
