>>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"