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/
