[RBASE-L] - RE: R> Success vs. .RMD Failure

[Buddy]

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: rbase-l@rbase.com [mailto:rbase-l@rbase.com] 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