Click or drag to resize

IDatabaseGetList Method

Returns a collection of list items for a given list item table.

Returns IListTextItems containing all the items in the given table, filtered and grouped according to the current user's group, but without the headings.

Note that items that are repeated under more than one heading will be repeated in the list.

Namespace:  SuperOffice.COM.SuperOfficeDB
Assembly:  SuperOfficeDB.Interop (in SuperOfficeDB.Interop.dll) Version: 8.0.0.0
Syntax
IListTextItems GetList(
	SOTableId TableId
)

Parameters

TableId
Type: SuperOffice.COM.SuperOfficeDBSOTableId
the numeric database identifier

Return Value

Type: IListTextItems
ListTextItems – a collection of ListText objects
Examples

Get information from the DocTmpl table

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

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

See Also