ListSeek (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Type of search
parameter
Uppercase/Lowercase characters
Seeking and selecting an element in a List Box or Combo Box control
Seeking an element in a browsing List Box or Combo Box control: search on the stored value or on the displayed value
Search and selection in a List Box control
Miscellaneous

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

ListSeek (Function)

In french: ListeCherche

Seeks an element in a List Box control (standard list box or listview) or in a Combo Box control (including the values described by gLink). Note: ListSeek can be used on:

the browsing or memory List Box controls,
single-selection or multiselection Looper controls.

Example

// Find the element "Moore" in the List Box control "LIST_CustomerList"
ResSeek = ListSeek(LIST_CustomerList, "Moore")

// Find the element "Moore" in the browsing List Box control "LIST_CustomerList"
// Exact-match search from element 5
ResFind = ListSeek(LIST_CustomerList, "Moore", True, 5)

Syntax

<Result> = ListSeek(<List Box control> , <Sought element> [, <Type of search> [, <Start of search>]])

<Result>: Integer

Subscript of element found.
-1 if no element corresponds to the search.
The element found is not selected. To select the element found, use ListSelectPlus.

<List Box control>: Control name

Name of List Box (or Combo Box) control to use.
If this parameter corresponds to an empty string (""), the element is searched in the control to which the current event belongs.

<Sought element>: Character string (with quotes)

Element to find in the specified List Box (or Combo Box) control.

<Type of search>: Optional boolean

True (default value) for an exact-match search,
False for a generic search.

<Start of search>: Optional integer

Subscript from which the search will start in the List Box or Combo Box control.
If this parameter is not specified, the search is performed in the entire control. This parameter is ignored for the memory List Boxes.

Remarks

Type of search

Exact-match search:
The elements whose value is strictly equal to <Sought element> are returned by ListSeek. For example:

// Return all the customers named "Doe" found in "LIST_Name"
ListSeek(LIST_Name, "Doe")
Generic search:
The elements starting with <Sought element> are returned by ListSeek. For example:

// Return all customers whose name starts with "SMI"
ListSeek(LIST_Name, "SMI", False)

<Start of search> parameter

The <Start of search> parameter is used to find all the occurrences of a string in a List Box or Combo Box control.

For example, to count the number of names starting with "SMI" in the "LIST_CustomerList" control:

Subscript is int
Cnt is int = 0
// Position on the first corresponding element
Subscript = ListSeek(LIST_CustomerList, "SMI", False)
WHILE Subscript <> -1
Cnt++
// Find the next name starting with "SMI"
Subscript = ListSeek(LIST_CustomerList, "SMI", False, Subscript + 1)
END

Uppercase/Lowercase characters

If the control is a memory List Box control, the search ignores the uppercase and lowercase characters.
If the control is a browsing List Box control, the search performed on the "Key" items takes into account the search options defined in the data model editor ("General" tab of the item description).

Seeking and selecting an element in a List Box or Combo Box control

To seek and/or select an element in a browsing List Box or Combo Box control, you can use the following syntax:

LIST_OrderList..StoredItem = "CustomerID"
// Find and select the element whose CustomerID is "135"
LIST_OrderList = 135
// If the element sought is not found, LIST_OrderList will be set to -1

Seeking an element in a browsing List Box or Combo Box control: search on the stored value or on the displayed value

Case 1: The List Box or Combo Box control is filled by a data file ("Direct access" option):
The search is performed according to the value of gLinkActivate:

If gLinkActivate(Control, True) (by default): ListSeek performs the search on the "search item" declared in the "Content" tab of control description.
If gLinkActivate(Control, False): ListSeek performs the search on the "displayed item" declared in the "Content" tab of control description.

Case 2: The List Box or Combo Box control is filled by a data file ("Loaded in memory" option):
ListSeek performs the search on the "displayed item" declared in the "Content" tab of control description.

Search and selection in a List Box control

If the options used to fill the List Box control are defined in the description window of the control ("Content" tab), the following syntax can be used to seek and select an element in a List Box control:

ListBoxName = SoughtElement

The options used to fill the List Box control are:

Browsed file,
Displayed item,
Search item.

Miscellaneous

To perform a search in a Table control or in a Combo Box control with table, use TableSeek.
ListSeek can be used on a "Combo Box" table column.

Component : wd250obj.dll