Reported By: Oliver Bock Reported On: 4/17/2007 For: Version 4.25 Build 4
# 2303IS NULL Does Not Work in a SELECT HAVING Clause HAVING does not support IS NULL or IS NOT NULL.
select SaleID, sum(SettleAmount) as Summed from Sale group by SaleID
having Summed is not null
Comments and WorkaroundsThe workaround is to use = NULL or <> NULL instead.
ResolutionFixed Problem on 1/2/2008 in version 4.26 build 1
Products AffectedDBISAM 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