Method
Returns the SumIndexFields of a specified table key.
Category
Keys.
Syntax
Function KeySumFields(ByVal hTable As Long, ByVal Key As Variant)
As Variant
hTable
The handle to the table.
Key
The key whose list of SumIndexFields is to be retrieved. This
parameter may represent either a primary or a secondary key.
Example
CF1.OpenTable hTable, 17 ' G/L account entry
longArray(0) = 3 ' field: "G/L Account No"
longArray(1) = 4 ' field: "Posting Date"
longArray(2) = 0
tmpVar = longArray
tmpVar2 = CF1.KeySumFields(hTable, tmpVar)
If (VarType(tmpVar2) = vbArray + vbLong) And (Not IsEmpty(tmpVar2)) Then
logWr "KeySumFields OK"
Else
logWr "KeySumFields failed"
End If
CF1.CloseTable hTable
Comments
KeySumFields retrieves a list of the SumIndexFields for a given key
and for a given table. SumIndexFields are a special C/SIDE feature
that permits speedy access to numeric amounts, even in tables that
contain thousands of records
For more information about keys and SumIndexFields, see the Application Designer’s Guide.