Reported By: Donat Hebert Reported On: 10/17/2005 For: Version 4.21 Build 10
# 2120Need 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;
ResolutionFixed Problem on 10/19/2005 in version 4.21 build 11
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 VCL Client-Server DBISAM VCL Client-Server with Source DBISAM VCL Standard DBISAM VCL Standard with Source