Icon View Incident Report

Serious Serious
Reported By: Elevate Software
Reported On: 1/25/2002
For: Version 3.04 Build 1
# 1012 Using COUNT(*) in a HAVING Clause Results in a Type Mismatch Error

Using COUNT(*) in a HAVING clause of an SQL SELECT statement results in a "type mismatch" SQL error, even though this is perfectly acceptable syntax.

SELECT CustNo, COUNT(*)
FROM Orders
GROUP BY 1
HAVING COUNT(*) > 0



Resolution Resolution
Fixed Problem on 1/23/2002 in version 3.05 build 1
Image