Click or drag to resize

IDatabaseGetAssociateList Method

Returns a list of associates (internal employees, associate.type=0) (internal employees, associate.type=0). Does not check if the associate is retired.

Namespace:  SuperOffice.COM.SuperOfficeDB
Assembly:  SuperOfficeDB.Interop (in SuperOfficeDB.Interop.dll) Version: 8.0.0.0
Syntax
SOAssociates GetAssociateList()

Return Value

Type: SOAssociates
SOAssociate – the specific associate record SOAssociates – a collection of associate objects
Examples

Retrieve the associate with id = 12

This text may be copied to the notepad, and saved as a *.vbs file. Remember to change the login information.

VB
dim objso
dim objassoc
set objso = CreateObject("superofficedb.database")
If not (objSO is nothing)  then
    objso.login "<username>",  "<password>"
    set  objassoc = objso.getassociate  (12)
    msgbox objassoc.fullname
else
    msgbox "unable to connect to database"
end if
set objso = nothing

Get list of associates

This text may be copied to the notepad, and saved as a *.vbs file. Remember to change the login information.

VB
dim objso
dim objassocs
set objso = CreateObject("superofficedb.database")
If not (objSO is nothing)  then
    objso.login  "<username>", "<password>"
    set  objassocs = objso.getassociatelist()
    for each item in objassocs
        msgbox item.fullname
    next
else
    msgbox "unable to connect to database"
end if
set objso = nothing

See Also