|
This function will retrieve the SUM of the
fields retrieved by the SQL statement.
TSUM(Field , SQL , Server)
PARAMETERS
Field
The field you wish to find the sum of. (Must be an INTEGER
field)
SQL
The SQL statement which determines which records to find the
sum of.
Server
The Server used to query against .. use --- for the local
device
Example:
Save
the sum value of FIELD1 into the textbox with tag name of
MYTEXT.
SETVALUE(~mytext~//TSUM({field1},"SELECT
field1 FROM
mytable","---")) |