EsbGetNextItem() retrieves next item from an array or list generated by calling other VB API functions.
EsbGetNextItem (hCtx, dType, pItem)
ByVal hCtx As Long ByVal dType As Integer pItem As Any
hCtx | Essbase VB API context handle. |
dType | Type of the array/list to retrieve item from: ESB_xxx...xx_TYPE, where xxx...xx is the name of a global constant,such as ESB_USERINFO_T . |
pItem | Buffer to receive the next item. |
Declare Function EsbGetNextItem Lib "ESBAPIW" (ByVal hCtx As Long, ByVal dType As Integer, pItem As Any) Sub ESB_GetNextItem () Dim Items As Integer Dim AppName As String Dim DbName As String Dim FilterName As String Dim User As String * ESB_USERNAMELEN Dim sts As Long AppName = "Demo" DbName = "Basic" FilterName = "Filter" '**************** ' Get Filter List '**************** sts = EsbGetFilterList (hCtx, AppName, DbName, FilterName, Items) '************************* ' Print out all user names ' from the list '************************* For n = 1 To Items '************************** ' Get next User Name String ' from the list '************************** sts = EsbGetNextItem (hCtx, ESB_USERINFO_TYPE, Userinfo) Print User Next End Sub
Global Constants for EsbGetNextItem
ESB_USERINFO_TYPE = 1 | ESB_USERINFO_T (EsbListUsers) |
ESB_GROUPINFO_TYPE = 2 | ESB_USERINFO_T (EsbListGroups) |
ESB_USERAPP_TYPE = 3 | ESB_USERAPP_T (EsbGetApplicationAccess) |
ESB_USERDB_TYPE = 4 | ESB_USERDB_T (EsbGetDatabaseAccess) |
ESB_LOCKINFO_TYPE = 5 | ESB_LOCKINFO_T (EsbListLocks) |
ESB_OBJINFO_TYPE = 6 | ESB_OBJINFO_T (EsbListObjects) |
ESB_APPDB_TYPE = 7 | ESB_APPDB_T (EsbListDatabases) |
ESB_CAPPDB_TYPE = 8 | ESB_APPDB_T (EsbListCurrencyDatabase) |
ESB_APPNAME_TYPE = 9 | ByVal var As String * ESB_APPNAMELEN (EsbListApplications) |
ESB_DBNAME_TYPE = 10 | ByVal var As String * ESB_DBNAMELEN (EsbGetApplicationInfo) |
ESB_GROUPNAME_TYPE = 11 | ByVal var As String * ESB_USERNAMELEN (EsbGetGroupList) |
ESB_FTRNAME_TYPE = 12 | ByVal var As String * ESB_FTRNAMELEN (EsbListFilters) |
ESB_FUSERNAME_TYPE = 13 | ByVal var As String * ESB_USERNAMELEN (EsbGetFilterList) |
ESB_OBJNAME_TYPE = 14 | ByVal var As String * ESB_OBJNAMELEN (EsbGetCalcList) |
ESB_DIMSTATS_TYPE = 15 | ESB_DIMSTATS_T (EsbGetDatabaseStats) |
ESB_CUSERINFO_TYPE = 16 | ESB_USERINFO_T (EsbListConnections) |
ESB_LAPPDB_TYPE = 17 | ESB_APPDB_T (EsbLogin) |
ESB_ALIASNAME_TYPE = 18 | ESB_ALIASNAME_T (EsbListAliases) |
ESB_MBRALT_TYPE = 19 | ESB_MBRALT_T (EsbDisplayAlias) |
ESB_RATEINFO_TYPE = 20 | ESB_RATEINFO_T (EsbGetCurrencyRateInfo) |
ESB_OUTLINEINFO_TYPE = 21 | ByVal var As String * ESB_ALIASNAMELEN (EsbOtlGetOutlineInfo) |
ESB_OUTERROR_TYPE = 22 | ESB_OUTERROR_T (EsbOtlVerifyOutline) |
ESB_OTLUSERATTR_TYPE = 23 | ByVal var As String * ESB_MBRNAMELEN (EsbOtlGetUserAttributes) |
ESB_APPINFOEX_TYPE = 24 | ESB_APPINFOEX_T (EsbGetApplicationInfoEx) |
ESB_DBREQINFO_TYPE = 25 | ESB_DBREQINFO_T (EsbGetDatabaseInfo) |
ESB_DIMINFO_TYPE = 26 | ESB_DIMENSIONINFO_T (EsbGetDimensionInfo) |
ESB_HMEMBER_TYPE = 27 | ESB_HMEMBER_T (EsbOtlQueryMembers) |
ESB_GENLEVELNAME_TYPE = 28 | ESB_GENLEVELNAME_T (EsbOtlGetGenNames) |
ESB_VARIABLE_TYPE = 29 | ESB_VARIABLE_T (EsbListVariables) |
ESB_LRO_TYPE = 30 | ESB_LRODESC_T |
ESB_PART_INFO_TYPE = 31 | ESB_PART_INFO_T |
ESB_DTS_TYPE = 32 | ESB_DTSMBRINFO_T (EsbGetEnabledDTSMembers) |
ESB_MBRNAME_TYPE = 33 | ESB_MBRNAME_T (EsbOtlGetDimensionUserAttributes) |