Sorry just not understanding. I'm doing a select of 10 columns from a table, could have 100 rows. A select of 10 columns exceeds the 79 characters or so that's getting written to one line I'm doing this: SELECT col1, col2, col3,....col10 FROM table WHERE.....
Karen -----Original Message----- From: Buddy Walker <[email protected]> To: rbase-l <[email protected]> Sent: Mon, Dec 16, 2019 1:44 pm Subject: RE: [RBASE-L] - Long embedded files in RMail #yiv0134910356 #yiv0134910356 -- _filtered #yiv0134910356 {panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv0134910356 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} #yiv0134910356 #yiv0134910356 p.yiv0134910356MsoNormal, #yiv0134910356 li.yiv0134910356MsoNormal, #yiv0134910356 div.yiv0134910356MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;} #yiv0134910356 a:link, #yiv0134910356 span.yiv0134910356MsoHyperlink {color:blue;text-decoration:underline;} #yiv0134910356 a:visited, #yiv0134910356 span.yiv0134910356MsoHyperlinkFollowed {color:purple;text-decoration:underline;} #yiv0134910356 p.yiv0134910356msonormal0, #yiv0134910356 li.yiv0134910356msonormal0, #yiv0134910356 div.yiv0134910356msonormal0 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;} #yiv0134910356 p.yiv0134910356msonormal0, #yiv0134910356 li.yiv0134910356msonormal0, #yiv0134910356 div.yiv0134910356msonormal0 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;} #yiv0134910356 p.yiv0134910356msonormal, #yiv0134910356 li.yiv0134910356msonormal, #yiv0134910356 div.yiv0134910356msonormal {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;} #yiv0134910356 p.yiv0134910356msochpdefault, #yiv0134910356 li.yiv0134910356msochpdefault, #yiv0134910356 div.yiv0134910356msochpdefault {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;} #yiv0134910356 span.yiv0134910356msohyperlink {} #yiv0134910356 span.yiv0134910356msohyperlinkfollowed {} #yiv0134910356 span.yiv0134910356emailstyle19 {} #yiv0134910356 p.yiv0134910356msonormal1, #yiv0134910356 li.yiv0134910356msonormal1, #yiv0134910356 div.yiv0134910356msonormal1 {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;} #yiv0134910356 p.yiv0134910356msonormal2, #yiv0134910356 li.yiv0134910356msonormal2, #yiv0134910356 div.yiv0134910356msonormal2 {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;} #yiv0134910356 span.yiv0134910356msohyperlink1 {color:blue;text-decoration:underline;} #yiv0134910356 span.yiv0134910356msohyperlinkfollowed1 {color:purple;text-decoration:underline;} #yiv0134910356 p.yiv0134910356msonormal01, #yiv0134910356 li.yiv0134910356msonormal01, #yiv0134910356 div.yiv0134910356msonormal01 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;} #yiv0134910356 p.yiv0134910356msonormal02, #yiv0134910356 li.yiv0134910356msonormal02, #yiv0134910356 div.yiv0134910356msonormal02 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;} #yiv0134910356 span.yiv0134910356emailstyle191 {font-family:sans-serif;color:windowtext;} #yiv0134910356 p.yiv0134910356msochpdefault1, #yiv0134910356 li.yiv0134910356msochpdefault1, #yiv0134910356 div.yiv0134910356msochpdefault1 {margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;} #yiv0134910356 span.yiv0134910356EmailStyle34 {font-family:sans-serif;color:windowtext;} #yiv0134910356 .yiv0134910356MsoChpDefault {font-family:sans-serif;} _filtered #yiv0134910356 {margin:1.0in 1.0in 1.0in 1.0in;} #yiv0134910356 div.yiv0134910356WordSection1 {} #yiv0134910356 You select the information into a variable then build your body as such So if you have three selects for your body I would do this SET VAR vBody = (.vSelect1 + (CHAR(013)) + .vSelect2 + (CHAR(013)) + .vSelect3) Then just use the variable vBody for your body. Buddy From: 'Karen Tellef' via RBASE-L <[email protected]> Sent: Monday, December 16, 2019 2:23 PM To: [email protected] Subject: Re: [RBASE-L] - Long embedded files in RMail The problem is that this is a 'select' of multiple columns of a table so each line really cannot wrap at all. So if I stick my select result into a NoteColumn and it wraps again in the email at 79 characters, it's going to wrap in the middle of my select statement. And if the data is in a temp table, the only way to get it into an email (as far as I know) is to write the data to a text file, which is basically what I'm doing now. Or is there another way to get a "select" statement as the body of an email? Karen -----Original Message----- From: Buddy Walker <[email protected]> To: rbase-l <[email protected]> Sent: Mon, Dec 16, 2019 1:07 pm Subject: RE: [RBASE-L] - Long embedded files in RMailKaren Instead of creating text files I would create a Temporary Table IDcolumn and either NoteColumn or VarCharColumn. Depending on size of body data. Insert info into Temp table Then when you select the body for your email you will select NoteColumn/VarCharColumn as your body base on a where clause if necessary. This way you shouldn’t have to change the length and when inserted into email it should wrap naturally. It has been a while since I did this so make sure to test. Buddy From: 'Karen Tellef' via RBASE-L <[email protected]> Sent: Monday, December 16, 2019 12:28 PM To: [email protected] Subject: [RBASE-L] - Long embedded files in RMail We create text files with select statements in them which will be used as the bodyof an RMail email. Before doing the select we set the width to 200 and the resultingtext file looks perfect. However, when embedding it as the body (see command below)it wraps at 79 characters. I added a "set width 200" command right before all thermail code but that doesn't make a difference. V1|LOAD_MESSAGE_BODY_FROM_FILE DashBoardRefresh.txt Is there a way I can do this? Thanks! Karen -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1793718183.9281758.1576517295143%40mail.yahoo.com.-- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/002b01d5b444%241ebdf900%245c39eb00%24%40comcast.net.-- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2055323552.9393587.1576524160959%40mail.yahoo.com.-- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/003401d5b449%2439f09ca0%24add1d5e0%24%40comcast.net. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/501490761.9383680.1576526107722%40mail.yahoo.com.
