|
WHILEOPT
|
|
| · | Don't clear your WHILE variable(s).
|
| · | Don't define variables within your WHILE loop, only outside the loop; values can change within the loop.
|
| · | Adhere to the syntax rules for the SWITCH statement by making sure that the argument for the SWITCH statement is an expression.
|
| · | 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.
|