Icon View Incident Report

Serious Serious
Reported By: Chris Erdal
Reported On: 3/7/2006
For: Version 4.22 Build 6
# 2174 Using Aggregate Expressions in SELECT Statement With UNION/INTERSECT/EXCEPT Causes Error

I get a complaint when doing the following union, but each SELECT on its own gives 5 columns.


SELECT locNum, amoY100M, tarMensuelTTC,
Reglements, CAST(0.0 AS MONEY) Solde
FROM memory\LocEtRgl
UNION 
SELECT locNum, MAX(amoY100M) amoY100M,
SUM(tarMensuelTTC) tarMensuelTTC, 
SUM(Reglements) Reglements, 
CASE WHEN SUM(Reglements) = NULL THEN (SUM(tarMensuelTTC))
ELSE (SUM(tarMensuelTTC)- SUM(Reglements)) END Solde
FROM memory\LocEtRgl
GROUP BY locNum
ORDER BY locNum, amoY100M



Resolution Resolution
Fixed Problem on 3/16/2006 in version 4.23 build 1


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

Image