>>>Not sure why it would ever work. I've never seen distinct written as a function the way you have, rather then as a keyword, like order by
>>>
>>>>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
>>
>>Perry,
>>It is not a function. However having parentheses there makes < g > "make" an expression column (and serves as a separator at command line). ie:
>>select (cust_id) from customer
>>select(cust_id) from customer
>>select top 1(emp_id) from orders group by 1
>>
>>Cetin
>
>Hi Cetin,
>in the VFP's grammar of VFP the spaces/tabs are ignored:
>

>? INT(1)
>? INT                     (1)
>
>? normalize("Distinc     (xx)")
>CREATE CURSOR byby (aa i)
>APPEND BLANK
>
>SELECT distinct (aa) aa FROM byby
>SELECT distinct(aa) aa FROM byby
>
>SELECT (distinct       (aa)) aa FROM byby
>
>FUNCTION distinct(x)
>  RETURN "distinct"
>
>

Yes that's what I meant.
Cetin