You know, as I thought more about it, ingested some more caffeine, I realized that for what I was really trying to accomplish, I should have used
LISTOF(DISTINCT MyColumn_B) because : - MY_TABLE has over 340,000 records - MyColumn_B is a DatePeriod attribute (CCYYMM) on the MANY-side and it has a rather limited number of DISTINCT values I appreciate too that you reminded me that the data-type of the ReturnValue from LISTOF() is NOTE. Thanks, Steve in Memphis ----- Original Message ----- From: "Lawrence Lustig" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, July 01, 2004 8:52 AM Subject: [RBASE-L] - Re: "Row overflow ..." Message > > Is this a situation where I've "overflowed" the > > bounds for the return_value of LISTOF()? > > > > Any suggestions? > > At a guess, an intermediate data set is being > generated to hold the result of your SELECT statement > and yes, the value being returned to LISTOF either > overflows the size of the NOTE field or else it is > still smaller than the NOTE field but the it makes the > row too large to fit in 4K, which is the largest > allowable row size in R:Base. > > In the former case, I think you don't have much option > -- LISTOF returns a NOTE type and notes are limited to > 4K. > > In the latter case, you could either remove some other > columns from the SELECT statement if you don't need > them, or remove the LISTOF column and then, if you > need it in a report, use a lookup to get the data > there. > -- > Larry >
