>Cetin,
>
>>"A table field takes a precedence over field alias name." Who decides that? VFP9 created a rule specific to itself?
>
>That's the rule VFP engine uses since forever. Too bad it's not documented.
>
>>It looks like a bug to me. What other VFP version or database system doesn't accept it as a bug. Doesn't make sense to me to create such a rule specific to a single version of a single tool. In the same manner each bug could be explained "it's a specific rule to this version". Out of VFP9 it stands as a bug.
>>
>>
select distinct city,right(Rtrim(city),3) as country ;
>> from (_samples+'data\customer') myCursor order by country
>>
>>should not error and the ordering should be right. However the bug was only in ordering in previous versions. Now "if it's giving an error", it's a bigger bug. Period.
>
>First you called something a bug w/o checking if it was a bug. Now you call above a bug just because you don't like it. I expected better from you.
I listened to you and Aleksey,
and installed VFP9 to test myself. It's a BUG. See my reply to Aleksey.
"That's the rule VFP engine uses since forever. Too bad it's not documented."
Too bad it's the rule for VFP that's not fixed when the engine has changed.
Cetin