Icon View Incident Report

Minor Minor
Reported By: Jose Eduardo Helminsky
Reported On: 7/31/2006
For: Version 4.24 Build 1
# 2209 Using an Invalid HAVING Clause in a SELECT Statement Causes AV

I try to execute the following SQL statement and receive AV I know the HAVING clause is incomplete but AV is not a proper error message.

select emp,num,count(*) as x from hino
group by emp,num
having x



Resolution Resolution
Fixed Problem on 8/1/2006 in version 4.25 build 1


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM ODBC Trial
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source
DBISAM VCL Trial

Image