>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.