Icon View Incident Report

Serious Serious
Reported By: Jirayu
Reported On: 2/3/1999
For: Version 1.09 Build 1
# 275 Using 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 Comments and Workarounds
Problem was with the parsing of the ORDER BY and GROUP BY clauses in the SQL.


Resolution Resolution
Fixed Problem on 2/3/1999 in version 1.10 build 1
Image