EsbOtlDeleteMemberFormula() deletes the formula for the specified member.
EsbOtlDeleteMemberFormula (hOutline, hMember)
ByVal hOutline As Long ByVal hMember As Long
| hOutline | Outline context handle. |
| hMember | Member handle. |
Returns 0 if successful; otherwise one of the following:
OTLAPI_ERR_NOFORMULA
Declare Function EsbOtlDeleteMemberFormula Lib
"ESBOTLW" (ByVal hOutline As Long,
ByVal hMember As Long) As Long
Sub ESB_OtlDeleteMemberFormula()
Dim sts As Long
Dim Object As ESB_OBJDEF_T
Dim hOutline As Long
Dim hMemberProfit 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", hMemberProfit)
End If
If sts = 0 And hMemberProfit <> 0 Then
sts = EsbOtlDeleteMemberFormula(hOutline, hMemberProfit)
End If
End Sub