Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Mon, Oct 5 2009 5:46 PM	Permanent Link
Thor	(Running Dbisam 3.26 still.) I wonder how to get integer result from my query (SELECT .... SUM(A.BKavg) ... No round or trunc is allowed it seems.
Tue, Oct 6 2009 3:10 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Thor (SELECT .... CAST(SUM(A.BKavg) AS INTEGER) ... I don't know if you can do it with aggregate functions back in V3 though Roy Lambert
Tue, Oct 6 2009 12:37 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Roy, << I don't know if you can do it with aggregate functions back in V3 though >> No - only 4.x. -- Tim Young Elevate Software www.elevatesoft.com