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
