# EsbOtlGetMemberFormula

Description

EsbOtlGetMemberFormula() gets the formula for the specified member.

Syntax

    EsbOtlGetMemberFormula (hOutline, hMember, pszFormula, usBufSize)

    ByVal hOutline   As Long
    ByVal hMember    As Long
    ByVal pszFormula As String
    ByVal usBufSize  As Integer

Parameters

hOutline | Outline context handle.
hMember | Member Handle.
pszFormula | Return variable for the member formula. The buffer is allocated by the caller, and the length is specified in the usBufSize parameter.
usBufSize | Size of the pszFormula buffer.

Return Value

Returns 0 if successful.

Example

    Declare Function EsbOtlGetMemberFormula Lib
    "ESBOTLW" (ByVal hOutline As Long, ByVal hMember
    As Long, ByVal pszFormula As String, ByVal usBufSize
    As Integer) As Long

    Sub ESB_OtlGetMemberFormula()
    Dim sts As Long
    Dim Object As ESB_OBJDEF_T
    Dim hOutline As Long
    Dim hMemberProfit As Long
    Dim szFormula As String * 100

    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",
        hMemberProfit)
    End If

    If sts = 0 And hMemberProfit <> 0 Then
       sts = EsbOtlGetMemberFormula(hOutline,
        hMemberProfit, szFormula, 100)
    End If
    End Sub

See Also

EsbOtlSetMemberFormula()
EsbOtlDeleteMemberFormula()