EsbListDrillThruURLs

Lists the drill-through URLs within the active database outline.

Syntax

Declare Function EsbListDrillThruURLs Lib "esbapin" (ByVal hCtx As Long, ByRef URLNames As Variant) As Long

Parameter	Description
hCtx	Visual Basic API context handle
URLNames	List of URL names

Return Value

If successful, lists names of drill-through URLs in the active database outline.
If unsuccessful, returns an error code.

Access

Caller must have database Read privilege (ESB_PRIV_READ) for the specified database.
Caller must have selected the specified database as their active database using EsbSetActive().

Example

Sub ESB_ListGLDrillThru()
   Dim intX       As Integer
   Dim URLNames   As Variant

   sts = EsbListDrillThruURLs(hCtx, URLNames)

   If sts = 0 Then
      Debug.Print "EsbListDrillThruURLs sts: " & sts

      For intX = LBound(URLNames) To UBound(URLNames)

      Debug.Print "URL Name: " & URLNames(intX)

      Next
   End If
End Sub

See also an extended example in Drill-through Visual Basic API Example.