>This line of code works in VFP 7 but causes an error in VFP 9. What's the problem?
>
>select distinct(make) as make from car_type into cursor ccar_type order by make
>
>The error is 1808 - Message= SQL: ORDER BY clause is invalid.
>
>Calvin

This is a bug for me, because the order is not ambiguous.

These works.

select distinct(make) as make from car_type into cursor ccar_type order by 1

select distinct(make) as make1 from car_type into cursor ccar_type order by make1

select distinct make as make from car_type into cursor ccar_type order by make

select distinct make from car_type into cursor ccar_type order by make