Many thanks, Razzak - I had a feeling it wasn't meant to but it's nice to know for sure (and, afaik, it's no different now than in v6.5++).
That's a timely reminder about the limit of 4k for notes, too, as I was beginning to think about using MikeB's "big file" list box in a trial to see if it suited my purposes. Regards, Alastair. ----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, July 22, 2004 10:01 AM Subject: [RBG7-L] - Re: Sorting ListOf > > At 07:41 AM 7/22/2004 +0100, Alastair Burr wrote: > > > ... should the order by clause work? > > > Alastair, > > No. > > The LISTOF function is categorized as "Aggregate Function" > and ORDER BY or GROUP BY clauses are not supported when > using AVG,COUNT,MAXIMUM,MINIMUM,STDEV,SUM,VARIANCE or LISTOF > function. (should work exactly as in 6.5++) > > Your approach of projecting a table or creating a VIEW with > required pre-sorted data should be ideal for LISTOF values. > > Also, keep in mind that the LISTOF function returns a NOTE > type and notes are limited to 4K, unless pre-defined as > TEXT otherwise. > > For more details and examples, see help files. > > Hope that helps! > > Very Best R:egards, > > Razzak. >
