>>>>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
This fail too, because make is a expression:
select distinct make as make from car_type into cursor ccar_type order by make