Bruce,
Trial and error. If one way doesn't work and you know it works at the command promp, try another approach. Jan -----Original Message----- From: "Bruce Chitiea" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Mon, 09 Jul 2012 09:19:56 -0700 Subject: [RBASE-L] - RE: R> Success vs. .RMD Failure: .RMD Success Buddy: Thank you. That works perfectly. I suppose my next question would be: 'Is there a reliable general rule prescribing the use of this approach?' Much appreciated, Bruce -------- Original Message -------- Subject: [RBASE-L] - RE: R> Success vs. .RMD Failure From: "Buddy" <[email protected]> Date: Sun, July 08, 2012 4:19 pm To: [email protected] (RBASE-L Mailing List) Bruce You might want to try something like this. SET VAR vq = (CVAL('QUOTES')) -- This should be set outside of the while loop SET VAR vDoUpdate TEXT -- This should be set outside of the while loop SET VAR vDoUpdate = ('UPDATE F2DFHtest SET' & .vColName & '=' & .vq + .vcolvalue + .vq & 'WHERE serno LIKE' & .vq + .vserno + .vq & 'AND' & .vColName & 'IS NULL' &vDoUpdate I'm assuming vcolvalue and vserno are text. If not then just remove the .vq Buddy -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bruce Chitiea Sent: Sunday, July 08, 2012 6:29 PM To: RBASE-L Mailing List Subject: [RBASE-L] - R> Success vs. .RMD Failure 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
