>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
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 curCustormerI hope this helps you.