DbServer.Count Method | |
Return the number of records that match a specified scope.
Namespace:
VO
Assembly:
VORDDClasses (in VORDDClasses.dll) Version: 2.21
Syntax VIRTUAL METHOD Count(
cbForBlock,
cbWhileBlock,
uScope
) AS USUAL CLIPPER
[ClipperCallingConventionAttribute(new string[] { ... })]
public virtual Usual Count(
Usual cbForBlock = default,
Usual cbWhileBlock = default,
Usual uScope = default
)
Request Example
View SourceParameters
- 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
Type:
Usual
The number of records that match the scope.
Remarks
Sends a NotifyIntentToMove message before the operation.
Sends a NotifyRecordChange message upon completion.
On successful completion, the current record will be the last file record and DBServer:EOF will be TRUE.
Examples
Compare with the way the COUNT command is used:
1COUNT TO nBranchCnt FOR Branch = 100
2nBranchCnt := oDBSales:Count({||Branch=100})
See Also