EsbOtlSortChildren

Description

EsbOtlSortChildren() sorts the children of an outline member.

Syntax

EsbOtlSortChildren (hOutline, hParent, usType)
ByVal hOutline As Long
ByVal hParent  As Long
ByVal usType   As Integer

Parameters

hOutlineOutline context handle.
hParentHandle of parent of the children to sort. If this is ESB_NULL, the dimensions are sorted.
usTypeSort type. This can be one of the following:
ESB_SORT_ASCENDING
ESB_SORT_DESCENDING

Return Value

Returns 0 if successful; otherwise one of the following:

OTLAPI_BAD_SORTTYPE
OTLAPI_BAD_SORTCOMPAREFUNC
OTLAPI_SORT_TOOMANY

Example

Declare Function EsbOtlSortChildren Lib 
"ESBOTLW" (ByVal hOutline As Long, ByVal hParent As Long, 
ByVal usType As Integer) As Long

Sub ESB_OtlSortChildren()
Dim sts As Long
Dim Object As ESB_OBJDEF_T
Dim hOutline As Long
Dim hParent As Long

Object.hCtx = hCtx
Object.Type = ESB_OBJTYPE_OUTLINE
Object.AppName = "Sample"
Object.DbName = "Basic"
Object.FileName = "Basic"

sts = EsbOtlOpenOutline(hCtx, Object, 
ESB_YES, ESB_YES, hOutline)

If sts = 0 Then
   sts = EsbOtlFindMember(hOutline, "Profit", hParent) 
End If

If sts = 0 And hParent <> 0 Then
   sts = EsbOtlSortChildren(hOutline,
    hParent, ESB_SORT_DESCENDING) 
End If
End Sub

See Also

EsbOtlFindMember()