Javier:
The RBEdit v. R> Prompt "issue" proved to be sloppy testing on my part
... I did not account for a [ SET VAR vq TEXT = NULL ] statement in my
"test rig".
Buddy:
I had simplified my example to focus on the cleanest case possible. The
actual code is:
SET VAR vFSPLeadTAG = +
('(IFNULL(T1.FSPLeadTAG,NULL, +
(' + .vq + '- ' + .vq + ' + T1.FSPLeadTAG + +
' + .vq + ' -' + .vq + ')))' )
My SNAFU last night and your responses today have set me down the path
to understanding.
I am in your debt.
Bruce Chitiea
SafeSectors, Inc.
909.238.9012 mobile
------ Original Message ------
Sent: 3/1/2016 3:50:09 PM
Subject: [RBASE-L] - RE: Quoting Behaviour: RBEdit v. R> Prompt
From: "Buddy Walker" <[email protected]>
To: [email protected]
Cc:
Bruce
When I set the variable as shown see the results. I’m assuming you
wanted the quotes around t1.Humpty…..
SET VAR vq = (CVAL(‘QUOTES’))
SET VAR vGreatFall TEXT = ('(' + .vq + 't1.Humpty' + .vq + ',' + .vq +
't2.Dumpty' + .vq + ')' )
sho var vgREATfALL
('t1.Humpty','t2.Dumpty')
Buddy
From:[email protected] [mailto:[email protected]] On Behalf Of Javier
Valencia
Sent: Tuesday, March 1, 2016 5:26 PM
To:[email protected]
Subject: [RBASE-L] - RE: Quoting Behaviour: RBEdit v. R> Prompt
Make sure to run this command to get the quotes into a variable…
SET VAR vq TEXT = (CVAL('Quotes'))
This is likely why the quotes do not show up.
Javier,
Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137
From:[email protected] [mailto:[email protected]] On Behalf Of Bruce
Chitiea
Sent: Tuesday, March 01, 2016 3:55 PM
To:[email protected]
Subject: [RBASE-L] - Quoting Behaviour: RBEdit v. R> Prompt
All:
RGBXE
If I run this code from within the editor:
SET VAR vq TEXT = (CVAL('Quotes'))
SET VAR vGreatFall TEXT = ('(t1.Humpty + ' + .vq + ', ' + .vq + ' +
t2.Dumpty)')
SHOW VAR vGreatFall
... I get the desired result at the R> output screen:
(t1.Humpty + ', ' + t2.Dumpty)
... If I run the SAME code from the R>, I get:
(t1.Humpty + , + t2.Dumpty)
... no quotes.
Is there a setting I'm missing?
Bruce Chitiea
SafeSectors, Inc.
909.238.9012 mobile
