Bruce, I have this same product so thanks for the suggestion. I have not done that for this information so I may just give it a try.
Jim -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bruce A. Chitiea Sent: Friday, July 26, 2013 1:57 PM To: RBASE-L Mailing List Subject: [RBASE-L] - OT: EverNote R:Base Code Templates I learn so much on this list every day. Easy to lose track, there's so much. So for a month now, I've been capturing solutions as copy-and-paste templates into a cloud-based product called EVERNOTE. EverNote allows keywording and content searching. By way of example, today's thread has been summarized and stored as follows: --Start Example --The LISTOF function concatenates column values into a comma-separated list. --1. Capture the list of column values into a source variable --2. Wrap the ColumName with four (4) quotes to capture all <spaces> --3. Wrap the source variable with parentheses to create the target variable --4. Ampersand the target within the test statement SELECT LISTOF('''' + Dumpty + '''') INTO vDumptyList FROM zEggMan SET VAR vHumpty TEXT = ('(' + .vDumptyList + ')') IF vPPiper NOT IN &vHumpty THEN ... --End Example EverNote is free; a subscription Premium version provides more value. Hope this helps Bruce -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Javier Valencia Sent: Friday, July 26, 2013 11:39 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: SELECT not allowed within IF statement The suggestion of using quotes around the returned values is a n excellent one and will prevent problems when you have embedded spaces and/or commas. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137
