At 09:38 PM 4/17/2005, Chuck Finley wrote:
When I run a 'trace' it runs fine! When I use the 'run' command
I get a error
-ERROR- Expression does not return a valid DATE (2158)
-ERROR- SET Error Command (3031)
Chuck,
FYI, TRACE always runs with WHILEOPT OFF.
I suggest that you take a look at all pre-defined variables
and make sure that they are defined with CORRECT data types.
01. Always pre-define all variables with correct data types
as NULL before the WHILE loop.
02� Don't clear your WHILE variable(s).
03. Never CLEAR any variable(s) within the WHILE loop. You
may set and pre-defined variable as NULL, if necessary.
04� Don't define variables within your WHILE loop, only
outside the loop; values can change within the loop.
05� Adhere to the syntax rules for the SWITCH statement by
making sure that the argument for the SWITCH statement
is an expression.
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.
Hope that helps!
Very Best R:egards,
Razzak.
