DB.GetStatistics

Description

Returns an array of aggregate values (Min,Max,Sum,Count,Avg) for the field(s) specified in the input parameter. Select is not needed for this method to operate. Scope object's setup is used for records filtering.

Syntax

Function GetStatistics("FUNC(field_name)"|Array("FUNC(term_name)",...))

Parameters

"FUNC(field_name)"|Array("FUNC(term_name)" (input) - An aggregate function name, or an array of aggregate function names

Return value

variant - an aggregate value for the aggregate function, which was passed in as a parameter; an array of variants - if an array of aggregate functions was passed in as a parameter, each array element holds an aggregate value for the respective aggregate function.

Example

Sample code

Dim aggregate_values, f1, f2, f3

DB.Scope.Set( "Field1 > 1000" )

aggregate_values = DB.GetStatistics( Array( "Count(Field1)", "Sum(Field2)", "Avg(Field3)" ) )