At 11:26 PM 8/15/2010, J BLAUSTEIN wrote:
Can some one explain why when I trace rhe below code everything
works correctly - but when I input I get the following error -
J,
FWIW, when TRACing a code, the WHILEOPT setting is set to OFF.
By default, the WHILEOPT is SET to ON.
SET WHILEOPT improves the optimization and processing of WHILE ...ENDWHILE
loops within applications by pre-compiling variables used within the WHILE
loop. Follow these guidelines:
. Don't define variables with correct data type within your WHILE loop,
only outside the loop; values can change within the loop.
. Don't clear your WHILE variable(s). Set them to NULL, when appropriate.
. 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.
Having explained that, take a look at your code and see if it follows the
rules of WHILE ... ENDWHILE. It certainly does not.
Updating your code accordingly should work without an -ERROR-.
Hope that helps!
Very Best R:egards,
Razzak.
--- 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.
================================================
