Agile Business Suite Application Lists

The Component Enabler product supports use of lists of values generated by an Agile Business Suite System. These lists can be created using either the SendListStatic command or the SendList.Dynamic command. Typically these lists consist of two columns of data (although they can contain more than two columns) where one column contains the code value of an item (such as a branch number) and the second contains a description of the code (such as the corresponding branch name).

For example, an application might have generated a list of branch number and codes and assigned the list the name *.BRANCHES as shown in the following list.

  1. Cheltenham

  2. Leeds

  3. Oxford

To use this list within a Component Enabler application, the application must first obtain a reference to the list using the GetLINCList method call.

Dim objBranchList As LINCList

Set objBranchList = LINCAPP.GetLINCList("*.BRANCHES")
If objBranchList is Nothing Then
      MsgBox "List box not found"
      Exit Sub
End If
’List can now be used

When the method GetLINCList is executed, Component Enabler first checks to see if it has a local copy of the list. If a local copy is available, this copy of the list is used in subsequent method calls. If a copy of the list is not available, Component Enabler automatically requests the list from the host system. If the list is not available (for example, because an invalid list name was supplied) the object is set to nothing. Otherwise the object is set to a reference to the LINCList object.

Note: Columns and rows are zero relative so in the above example, the code values are held in column zero and the associated data values are held in column one.