All: Embedded within a cursor-driven RMD file, this code fails to update the target column without throwing an error message. At the R> immediately afterward, having not cleared global variable values, the code performs the update.
UPDATE F2DFHTest + SET &vcolname = .vcolvalue + WHERE serno LIKE .vserno + AND &vcolname IS NULL All other functions and aspects of the cursor-driven process work as expected. TRACE shows that all variable values are as expected at the point of arrival. EQNULL has been set both ON and OFF. Thoughts? Bruce --- RBASE-L =======================3D=======================3 D= 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) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= 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. =======================3D=======================3 D=
