[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
SUM
Sum numeric expressions and assign results to variables
------------------------------------------------------------------------------
Syntax
SUM <nExp list> TO <idVar list>
[<scope>] [WHILE <lCondition>] [FOR <lCondition>]
Arguments
<nExp list> is the list of numeric values to sum for each record
processed.
TO <idVar list> identifies the receiving variables to be assigned
assign the results of the sum. Variables that either do not exist or
are not visible are created as private variables. <idVar list> must
contain the same number of elements as <nExp list>.
<scope> is the portion of the current database file to SUM. The
default scope is ALL records.
WHILE <lCondition> specifies the set of records meeting the
condition from the current record until the condition fails.
FOR <lCondition> specifies the conditional set of records to SUM
within the given scope.
Description
SUM is a database command that totals a series of numeric expressions
for a range of records in the current work area and assigns the results
to a series of variables. The variables specified in <idVar list> can
be field, local, private, public, or static.
Note that the <nExp list> is required and not optional as it is in other
dialects.
Examples
. This example illustrates the use of SUM:
LOCAL nTotalPrice, nTotalAmount
USE Sales NEW
SUM Price * .10, Amount TO nTotalPrice, nTotalAmount
//
? nTotalPrice // Result: 151515.00
? nTotalAmount // Result: 150675.00
Files Library is CLIPPER.LIB.
See Also:
AVERAGE
DBEVAL()
TOTAL
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson