Can somebody help me continue this code? 1

[pando]

Can somebody help me continue the code below to retrieve Livelink users list?

Thank you very much.



Dim session As LLSession
Dim users As LAPI_USERS
Dim table As LLValue
Dim status As Long
Dim message As String
Dim errMsg As String
Dim apiError As String


session = New LLSession("landz",
2099, "Livelink", "Admin", "livelink&quot
users = New LAPI_USERS(session)
table = New LLValue().setAssocNotSet

Dim i As Long

If (status = users.ListUsers(table)) Then


End If



message = session.getStatusMessage
errMsg = session.getErrMsg
apiError = session.getApiError
Console.WriteLine("Session failure status is " +
status.ToString + " (0x" + status.ToString)
If (message <> &quot;&quot And (errMsg <> &quot;&quot And (apiError <> &quot;&quot
Then
Console.WriteLine(&quot;Message=&quot; + message)
Console.WriteLine(&quot;errMsg=&quot; + errMsg)
Console.WriteLine(&quot;apiError=&quot; + apiError)
End If

 

[appnair]

the table kuaf holds all information of the livelink users.can't you just query it with VB rather than using LAPI.If you would rather have it thru LAPI I may be able to do something with java.VB ain't my cup of tea.

SELECT LIVELINK_KUAF.NAME, LIVELINK_KUAF.DELETED, LIVELINK_KUAF.USERPRIVILEGES, LIVELINK_KUAF.LASTNAME, LIVELINK_KUAF.MIDDLENAME, LIVELINK_KUAF.TITLE, LIVELINK_KUAF.ID, LIVELINK_KUAF.GROUPID
FROM LIVELINK_KUAF
WHERE (((LIVELINK_KUAF.DELETED)=0));

The above query I'm using thru access thru an ODBC connection to the livelink database.the where clause is what I do to filter inactive users.You can check whether query works with a live report too and execute the livereport with the document api RunReport method.