>>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
>
>You can add DESCENDING after CREATED in the select statement. Or you can Index on acclient + dtoc(created,1) tag something.
Thanks a lot
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing