DbServer.Total Method (Typed)

 VIRTUAL METHOD Total(
	oFSTarget,
	cbKeyField,
	aFieldList,
	cbForBlock,
	cbWhileBlock,
	uScope
) AS LOGIC CLIPPER

[ClipperCallingConventionAttribute(new string[] { ... })]
public virtual bool Total(
	Usual oFSTarget = default,
	Usual cbKeyField = default,
	Usual aFieldList = default,
	Usual cbForBlock = default,
	Usual cbWhileBlock = default,
	Usual uScope = default
)

Parameters

oFSTarget (Optional)

Type: Usual
A string or filespec object that specifies the file to which the summary data is written.

cbKeyField (Optional)

Type: Usual
The key field in this server that is the basis for the summarization. Note that for the summarization to produce correct results, the table should be indexed or sorted on this key field.

aFieldList (Optional)

Type: Usual
An array of fields from the source file that are to be included. The default is all fields.

cbForBlock (Optional)

Type: Usual
The condition evaluated for each record in the scope; if TRUE, the record is included in the processing. It provides the same functionality as the FOR clause of record processing commands.

cbWhileBlock (Optional)

Type: Usual
The condition evaluated for each record from the first record until the condition returns FALSE. It provides the same functionality as the WHILE clause of record processing commands.

uScope (Optional)

Type: Usual
The range of records to process, providing the same functionality as the ALL, REST and NEXT clauses of record processing commands.

Constant	Description
DBSCOPEALL	The scope is all the records in the table. This is the default, although if a WHILE condition is specified, the scope becomes DBSCOPEREST.
DBSCOPEREST	The scope is the remaining records in the table from the current position.

Return Value

Reference