Albert, Are you suggesting that we all re-download the 9/19 update files?
Claudine -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Albert Berry Sent: Friday, October 24, 2008 3:55 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Difference in LISTOF command Make sure you download the latest version from the RBTI web site. There was a minor bug with LISTOF that was swatted by RBTI and submitted by me with help from Alastair Burt. This may or may not have an effect on your troubles, but why not? MikeB wrote: > Additionally, > > insert into tTellef colNote select ('''' + (listof(contid)) + '''') from > contact > > inserts the listOf integers, separated by commas into the table without a > hitch. > > 7.6 30919 in case you are wondering. > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" <[email protected]> > Sent: Thursday, October 23, 2008 4:14 PM > Subject: [RBASE-L] - Re: Difference in LISTOF command > > > >> Jim: Not sure what point you were trying to make. >> >> If I was selecting the LISTOF into a variable, my variable was pre-defined as >> a Note type to make sure it's large enough to return a comma-delimited string >> of items. If I was inserting the LISTOF into a table column, that column >> was defined as a Note datatype. >> >> It works fine in 7.6 as long as the data you are listing is a Text datatype, >> but in 6.5 it also worked if the data was Integer. This is what's not >> explicitly mentioned in the help file -- what the datatype of the column you >> are >> listing has to be so I assume it is supposed to work directly on all >> datatypes. >> >> The problem I was having in 7.6 is when the LISTOF is operating to get a list >> of data from an Integer column rather than a Text column. Using the same >> working 6.5 code, inserting the LISTOF into a note column gave me an error; >> putting a CTXT into the LISTOF fixed the problem. When I tried a >> workaround to >> instead select the LISTOF into a note-type variable, it sometimes worked and >> sometimes gave me a "truncate" error even though it was selecting only 1 or 2 >> items so it wasn't exceeding any length. >> >> Karen >> >> >> >> >>> Karen, >>> Here is the text from my v7.6 help file >>> "LISTOF >>> >>> >>> >>> The aggregate functions (AVG, COUNT, MAXIMUM, MINIMUM, STDEV, SUM, VARIANCE) >>> used in COMPUTE/SELECT commands now have a new member of their family called >>> "LISTOF" which creates a text string of the values separated by the current >>> comma delimiter character. >>> >>> >>> The LISTOF function can be used with the "SELECT ... INTO ..." to populate a >>> variable with a list of values which can then be used in a CHOOSE command >>> with the #LIST option. It can also be used in Forms, Reports or Labels to >>> look >>> up values from multiple rows. >>> >>> LISTOF returns a NOTE type and notes are limited to 4K. " >>> >>> This text does not reflect the latest enhancement which allows the >>> receiving varable to defined as variable character. >>> >>> To the best of my knowledge it has always returned a "TEXT" value. Also, >>> since you are returning "integers" (defined in a text variable) implicit >>> datatyping should allow you to use that variabvle as a valid argument to >>> "WHERE >>> integercol IN &textvarname" >>> >>> Jim Bentley >>> >>> >>> > > > >
