Icon View Incident Report

Minor Minor
Reported By: Donat Hebert
Reported On: 10/17/2005
For: Version 4.21 Build 10
# 2120 Need to Add Support for Using Aggregate Expressions in Single-Row Result Sets

The first query below works as expected, not requiring a group by clause. However, the second query indicates the need for a "group by" however none is required.

Select sum(Ftes) as Ftes
from Pratran_2005;

Select Round(sum(Ftes),2) as Ftes
from Pratran_2005;



Resolution Resolution
Fixed Problem on 10/19/2005 in version 4.21 build 11


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