> 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 --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [EMAIL PROTECTED] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
