Reported By: Jirayu Reported On: 2/3/1999 For: Version 1.09 Build 1
# 275Using Column Names for ORDER BY Clause Causes a Parse Error SQL works fine but the ORDER BY clause can not be used with field name like this:
select * from vendors order by Vendor_ID, Country
but
select * from vendors order by 1,7 works fine.
Comments and WorkaroundsProblem was with the parsing of the ORDER BY and GROUP BY clauses in the SQL.
ResolutionFixed Problem on 2/3/1999 in version 1.10 build 1