Hi Ali,
>select customer_id ;
> from Customer ;
> where customer_id in (16, 10, 12, 15, 8, 1) ;
> into cursor curCustormer
>How can I order the result cursor according to data in the set of inlist expressions
>Thank in advance
>Ali Altun
Try:
select customer_id, ;
iif(customer_id = 16, 0, iif(customer_id = 10, 1, iif(customer_id = 12, 2, iif(customer_id = 15, 3, iif(customer_id = 8, 4, 5))))) myNewField ;
from Customer ;
where customer_id in (16, 10, 12, 15, 8, 1) ;
order by myNewField ;
into cursor curCustormer
I hope this helps you.
Bye!
Erick
Força Sempre!
Strength Always!
