GetCursorFieldStatistics Method

Description

Get the statistics for a numeric field in the specified cursor.

Syntax

Visual Basic
Public Function GetCursorFieldStatistics( _ ByVal cursor As String, _ ByVal nField As Long _ ) As String

Parameters

cursor: The name of the cursor we are interrogating.
nField: The index number of the field we are interrogating, the index starts at 0.

Return Type

The field’s statistics as a string.

Remarks

The returned string contains a set of name-value pairs. In a pair the separator between the name and value is a TAB character. The separator between the name-value pairs consists of a Carriage Return character followed by a Line Feed character. If printed, the statistics string looks like:

Rows      2
Sum      16.32
Min       7.31
Max       9.01
Range     1.7
Mean      8.16
Median    8.16
Variance  0.722499999999997
Deviation 0.849999999999998

If GetCursorFieldStatistics is called on a non-numeric field a string is returned in the above format but all values are "0".

If you intend using this method repeatedly on the same cursor you should not open the cursor as 'Forward Only'.

Available: GEO D OD OM SISpy

Group:

Named Cursor Methods

Example

Dim rv As String = GisGetCursorFieldStatistics ("MyCursor", 0)

Get the statistics of the first field of the cursor into a string.