Razzak Wahoo!! This is yet another great new addition - you continue to amaze and delight!!
David ----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 01, 2002 3:49 AM Subject: Re: Limit to LISTOF Function? - Razzak's Reply > > David, > > I'm pleased to inform you that the Expression Result Limit of 20 characters > in newly introduced LISTOF aggregate function in 6.5++ has been removed. > > The upcoming in-line patch-3 for The Glorious R:BASE 2000 (ver 6.5++), > Build:1.589xRT03 will include that enhancement. > > Enjoy and make sure to have fun! > > Very Best Regards, > > Razzak. > > At 01:55 PM 8/26/2002 -0500, David Blocker wrote: > > >I'm writing an application to prepare a scheduling system for a company that > >transports special needs kids to school systems. The output desired should > >show the name of each child, the time and place they are picked up, then the > >"drop off" at the school, listing the kids with the school name, like this: > > > >Name Place Time > >Ken Richards 11 Jones Ave 6:45AM > >Christopher Raymond 11 Woodland Dr. 6:50AM > >Christopher McDonald 12 Robert Ave 6:55AM > >Sarah Gardner-Dickson 110 Friend St. 7:00AM > > > >Ken Richards, Christopher Triton Regional 7:10AM > >Raymond, Christopher High School > >McDonnald, Sarah > >Gardner-Dickson > > > >I'm accomplishing this quite well with a series of SELECTs unioned > >together. I'm having one minor problem with the SELECT that produces the > >"school stop" row. I'm using this to get the list of names: > > > >SELECT (SRPL (LISTOF( T1.RNameF & T1.RNameL),',',', ',0)) FROM ...... > > > >This works great, placing a space between the names after each comma, UNLESS > >the student's name (combined First + space + last) exceeds 20 characters, as > >in the last name above, Sarah. For each name, I get no more than 20 > >characters, with the rest truncated. What I get is this: > > > >Ken Richards, Christopher Triton Regional 7:10AM > >Raymond, Christopher High School > >McDonnald, Sarah > >Gardner-Dickso > > > >It doesn't matter where Sarah's name falls in the list, the "N" at the end > >of her name does not print: the cut off appears to be 20 characters. There > >is nothing at the RSyntax spot about a limitation of each item in a LISTOF > >cutting off at 20 characters, nor in the TXT file that came with that patch. > > > >Is there a limit? If not, can I do something to force R:Base to give me the > >full name, no matter how long it is? > > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
