>>>>>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.
>>
>>Maybe it gets confused?
>
>It certainly does. As I replied to Robert, it acts like this even with fully qualified prefixed with alias.
I stay away from using reserved words as much as possible. The funkiset things happen, and they usually take forever to figure out why.