Do this on a column that has more than 20 chars in a single col. select listof(someCol) from someTable where limit=4 (just a test so limit the output)
Do This select listof((someCol)) from someTable where limit=4 The items will be truncated at 20 chars. it appears that the parens from the view become a part of the actual structure of the ListOf when it acts on a view. Why the truncation occurs? Don't know. Workaround: The Old way, either output to a .MNU file if you are using it in a choose or to a temp table..... ----- Original Message ----- From: "Lawrence Lustig" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 26, 2002 4:07 PM Subject: Re: Limit to LISTOF Function? > > 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? > > David: > > I just played around with this using the ConComp database and got similar > results. I did > > SELECT LISTOF(ContFName & ContLName & ContPhone) + > FROM Contact WHERE ContLName LIKE 'A%' > > and got the following results: > > -WARNING- New value will be truncated. (2570) > -WARNING- New value will be truncated. (2570) > -WARNING- New value will be truncated. (2570) > -WARNING- New value will be truncated. (2570) > > LISTOF (ContFName & ContLName & ContPhone) > ---------------------------------------------------------------------- > Anna Adams 512-581-8,Nancy Allen 823-285-,Jerry Attwater 505-8,Margie > Amundsen 190- > > Notice that I got 4 warnings about truncation, and also that in the results > each set of data is truncated -- Anna Adams is missing 3 characters, Nancy > Allen is missing 4, Jerry Attwater is missing 7, and Margie Amundsen is > missing 8. Each row was limited to 20 characters, as you reported. > > I did my test on an older patch -- if you can confirm this ComComp example > on the latest and greatest, you should probably submit it to RDCC. > -- > Larry > > > ================================================ > 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/
