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/
