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.
