My thanks to Mike of RBTI. I added a new computed column to the table in question, RFull=(RnameF & RnameL) TEXT 30, and used that in the select instead and that fixed it!
David Blocker ----- Original Message ----- From: "Mike Willochell" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 26, 2002 4:47 PM Subject: Re: Limit to LISTOF Function? > Dear Guys; > > Please note that the documentation on the LISTOF function states > the following: > > SELECT (LISTOF(ColumnName)) INTO VariableName INDICATOR IndVar + > FROM TableView WHERE ... > > Any use of expressions within the LISTOF function will not behave as > expected as its capabilities have not been expanded to include this > functionality. > > A simple enough work-around using a temporary table with a computed > column as a precursor to the LISTOF command will resolve this problem. > > As per my testing, using the LISTOF function on any SINGLE column > has not shown ANY limitations when used as advertised. > > You can also safely imbed the LISTOF inside of an SRPL function with > good results as well. Example: > > SELECT (SRPL((LISTOF(column)),',',', ',0)) FROM ... > > Best Regards, > > Mike > > At 05:07 PM 8/26/2002 -0400, you wrote: > > > 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? > > ------------------------------------------- > Michael Willochell > Director, Customer Support > R:BASE Technologies, Inc. > 3935 Old William Penn Highway > Murrysville, PA 15668-1854 > Phone: 724-733-0053 > FAX: 724-733-0196 > URL: www.rbase.com > Sales: [EMAIL PROTECTED] > Support: [EMAIL PROTECTED] > ------------------------------------------- > > ================================================ > 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/
