Icon View Incident Report

Serious Serious
Reported By: Harry Van Tassell
Reported On: 1/31/1999
For: Version 1.09 Build 1
# 284 SQL ORDER BY Clause is Not Working Properly When Referencing Column Correlation Names

Using the DBDEMOS:Customers.db transfered to DBIXAM the following CrossTab SQL statment fails at the ORDER BY..

select count(*) Customers,State
from customer
where country='US'
group by state
order by customers DESC

Resolution Resolution
Fixed Problem on 1/31/1999 in version 1.10 build 1