I have an existing cursor statement which opens the cursor in ascending client then ascending created order
How do I change the order to ascending client then DESCENDING created order
Created is a datetime field
SELECT created,accountno,acclient,quoteref FROM quotation ;
WHERE ! EMPTY(created);
ORDER BY acclient ,created INTO CURSOR quotelist readwrite
Thanks
Colin
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing