>>As someone found the logic of VFP when using a field name DESC in a SQL? Sometimes, the same SQL will generate an error if a field name is Desc. Most of the times it'll work.
>
>DESC is a keyword in both VFP-SQL and T-SQL, as in:
>
>SELECT Name, City ;
>FROM Customers
>ORDER BY Name DESC
>
>
>so I would avoid it as a field name.
Yes, I know. My point was mostly to know why VFP sometimes accept it and sometimes it don't.