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]> [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]<mailto:[email protected]>> To: [email protected]<mailto:[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]> [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]> [mailto:[email protected]] On Behalf Of Bruce Chitiea Sent: Tuesday, March 1, 2016 2:34 AM To: [email protected]<mailto:[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
