Stephen:
True enough. I'll work with it.
A great demonstration model, by the way.
Thanks!
Bruce Chitiea
SafeSectors, Inc.
909.238.9012 mobile
------ Original Message ------
Sent: 3/2/2016 11:37:25 AM
Subject: [RBASE-L] - RE: Should've quit at dinner time
From: "Stephen Markson" <[email protected]>
To: [email protected]
Cc:
The rule for including your QUOTES character in text strings is: double
it. That should always work.
BTW, here's how I tested this:
R> CREATE TEMPORARY TABLE TempTable (Humpty TEXT 8,Dumpty TEXT 8)
R> INSERT INTO TempTable VALUES 'Smith','Fred'
R> SET V vGreatFall TEXT='(t1.Humpty+'',''&t2.Dumpty)'
R> SELECT &vGreatFall=30 FROM TempTable t1,TempTable t2
And got this result:
(t1.Humpty + ',' & t2.Dumpty)
------------------------------
Smith, Fred
Regards,
Stephen Markson
The Pharmacy Examining Board of Canada
416.979.2431 x251
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Bruce
Chitiea
Sent: March-02-16 11:50 AM
To: Stephen Markson
Subject: [RBASE-L] - RE: Should've quit at dinner time
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
