Stephen:
Correct on both counts, and thank you. This simple construction seems to
work sometimes, not others.
Yesterday's beyond-the-list quest for a rule regarding " ' " and
(CVAL('Quotes')) in ampersand-variable strings produced mixed results:
some success, mostly failure.
The rule is out there still; I've not put my finger on it yet.
Whatever it is, it's powerful stuff.
'Preciate ALL your help.
Bruce Chitiea
SafeSectors, Inc.
909.238.9012 mobile
------ Original Message ------
Sent: 3/2/2016 8:30:07 AM
Subject: [RBASE-L] - RE: Should've quit at dinner time
From: "Stephen Markson" <[email protected]>
To: [email protected]
Cc:
I think this works:
SET VAR vGreatFall TEXT = '(t1.Humpty + '', '' + t2.Dumpty)'
where '' is two single quotes - not a double quote.
I also think it would be clearer to remove the space after the comma and
use the & concatenator instead:
...'','' & t2...
Regards,
Stephen Markson
The Pharmacy Examining Board of Canada
416.979.2431 x251
From: [email protected] [mailto:[email protected]] On Behalf Of Buddy
Walker
Sent: March-01-16 10:33 AM
To: Stephen Markson
Subject: [RBASE-L] - RE: Should've quit at dinner time
Bruce
I would do it like this
SET VAR vq = (CVAL(‘QUOTES’))
SET VAR vGreatFall TEXT = ('(' + .vq + 't1.Humpty' + .vq + ',' + .vq +
't2.Dumpty' + .vq + ')' )
Buddy
From: [email protected] [mailto:[email protected]] On Behalf Of Bruce
Chitiea
Sent: Tuesday, March 1, 2016 2:34 AM
To: [email protected]
Subject: [RBASE-L] - Should've quit at dinner time
All:
I need to deliver this string into an ampersand variable:
(t1.Humpty + ', ' + t2.Dumpty)
... ala:
SET VAR vGreatFall TEXT = (t1.Humpty + ', ' + t2.Dumpty)
... and for the life of me I can't remember how to frame it up with
quotes and parens.
?? Thanks
Bruce Chitiea
SafeSectors, Inc.
909.238.9012 mobile
