ListSeek (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / WLanguage functions / Controls, pages and windows / List Box functions

Type of search
parameter
Uppercase/Lowercase characters
Seeking and selecting an element in a List Box or Combo Box control
Search in a List Box control or Combo Box control linked to data: search on the stored value or on the displayed value
Search and selection in a List Box control linked to data
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 gStoredValue).

In this version, the values described by gStoredValue cannot be sought.

Note: The ListSeek function can be used on both:

Data-linked List Box control or Programmed List Box control,
single-selection or multi-selection List Box controls.

Reminder: In this version, the List Box control fields are not available.

Example

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

// Search for "Dubois" in List Box control linked to "LISTE_ListeClient" data
// Exact-match search from element 5
ResFind = ListSeek(LIST_CustomerList, "Moore", True, 5)

Syntax

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

<Result>: Integer

Index of the element found.
-1 if no element corresponds to the search.
The element found is not selected. To select the element found, use ListSelectPlus.
In a List Box control linked to data, the item found is displayed if it is not visible.

<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.
The name of List Box or Combo Box control to use must necessarily be specified.

<Search element>: Character string

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.
This parameter is not available. An exact-match search is performed by default.

<Start of search>: Optional integer

Index 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 controls manipulated programmatically.
This parameter is not available. The search is performed in the entire control by default.

Remarks

Type of search

Exact-match search:
The elements whose value is strictly equal to <Search 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 <Search 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:

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

Uppercase/Lowercase characters

If the control is a List Box control populated programmatically, the search ignores the uppercase and lowercase characters.
If the field is a List Box control linked to data, the search on "Key" type fields takes into account the search options defined in the data model editor ("General" tab of the field description).

The search is case sensitive.

List Box controls based on a data file are not available.

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

To search and/or select an item present in a List Box control (or Combo Box control) linked to data, you can also 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

The sought element is selected.

Search in a List Box control or Combo Box control linked to data: search on the stored value or on the displayed value

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

If gStoredValueEnable(Field, True) (default): The function ListSeek FUNCTION searches on the "browse item" declared in the "Contents" tab of the field description.
If gStoredValueEnable(Field, False): The function ListSeek FUNCTION searches on the "displayed item" declared in the "Content" tab of the field description.

Case 2: The List or Combo Box control is fed by a data file ("Loaded into 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 linked to data

If the options used to populate 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 populate the List Box control are:

Data file,
Displayed item,
Search item.

Description of data-related List Box control

Miscellaneous

To search a table field or a Combo Box control, use the TableSearch function.
ListSeek can be used on a "Combo Box" table column.

Component: wd300obj.dll