Get SUM from MSSQL in Clarion

[Rick_UpperPark]

Another method is to use Prop:Name on a View. See in the Clarion help about view support for aggregate functions and Prop:Name - SQL.

VIEW support for aggregate functions

This is a pretty neat topic from the help. The SQL view engine supports PROP:GroupBy and PROP:Having. These properties allow you to add respectively GROUP BY and HAVING SQL clauses to your SELECT statement. PROP:GroupBy must be set first to allow PROP:Having to be generated. Example: PROGRAM MAP END EMP FILE,DRIVER('ORACLE'),NAME('EMP'),PRE(EMP) P_EKY_EMP KEY(EMP:EMPNO),NOCASE,OPT,PRIMARY KEY_DEP KEY(EMP:DEPTNO),DUP,NOCASE,OPT Record RECORD EMPNO SHORT …