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
