>>Hi all,
>>I find a strange behavior using 'DESC' and 'order by'. i.e. 'select lastname,firstname from myfile into cursor mycursor order by lastname,firstname desc' do not work. without 'desc' or without 'firstname' (with only one order by) it works.
>>Some suggest?
>>Thanx
>
>Francesco,
>
>You need to use the DESC keyword for each field that you want that order on. So,
>
>SELECT LastName, FirstName ;
> FROM MyFile ;
> INTO CURSOR MyCursor ;
> ORDER BY LastName DESC, FirstName DESC
>
>should do the trick.
>
>Regards
Thanx, I got a mistake.
Bye