ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Standard functions / Queue, stack, list and array functions / Array functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Seeks the index of an element in a WLanguage array. The following searches can be performed:
  • Seek an element in a one-dimensional array of simple elements.
  • Seek an element in a two-dimensional array of simple elements according to a column.
  • Seek an element in a two-dimensional array of simple elements according to several columns.
  • Seek an element in a one-dimensional array of structures or classes.
  • WINDEVWEBDEV - Server code Seek an element in an array of records.
  • Seek an object in an array.
Remarks:
  • This function is equivalent to ArraySeek.
  • PHP In PHP, the search cannot be performed in an array containing more than one dimension or in an array of structures.
Example
MyArray is array of 0 string
// Fill the array
Add(MyArray, "WINDEV")
Add(MyArray, "WEBDEV")
Add(MyArray, "WINDEV and WEBDEV")
// Find "WINDEV"
ResIndex is int
ResSubscript = Seek(MyArray, asLinearFirst, "WINDEV")
Info("The WINDEV string is found at index: " + ResIndex)
// Returns: "The WINDEV string is found at index: 1"
WINDEVWEBDEV - Server codeReports and QueriesUser code (UMC)
arrCalendar is array of gglCalendar
// Find a calendar identified by its title
Seek(arrCalendar, asLinear, "title", "Professional calendar")
Syntax

Seeking an element in a one-dimensional array of simple elements Hide the details

<Result> = Seek(<Array name> , <Type of search> , <Sought value> [, <Start index>])
<Result>: Integer
  • Index of the sought element,
  • -1 if the element is not found in the array.
<Array name>: Array
Name of the Array variable to use. This array must be a one-dimensional array.
This array can also correspond to an array of simple elements of an advanced variable.
<Type of search>: Integer constant
Type of search to perform:
asBinaryBinary search.
This search mode is fast but it must be used on an array sorted in ascending order, without duplicates (see ArraySort).
asLinearLinear search. The search starts:
  • from the first element.
  • from the value of the parameter <Start index>.
The search stops as soon as an element is found.
asLinearFirstLinear search from the first element. <Start index> is ignored when this constant is specified.
asLinearLastLinear search from the last element. This constant must not be used if <Start index> is specified.
asLinearNextLinear search for the next element. This search is performed from the current position or the value of <Start index>.
asLinearPreviousLinear search for the previous element. This search is performed from the current position or the value of <Start index>.
The type of search can be combined with one or more search options:
tccIgnoreAccentSearch ignoring accented characters.
This option can only be used on the arrays of character strings.
WEBDEV - Browser code This constant is not available.
tccIgnoreCaseSearch ignoring the case.
This option can only be used on the arrays of character strings.
tccIgnoreInsideSpaceSearch ignoring spaces inside strings.
This option can only be used on the arrays of character strings.
tccIgnorePonctuationAndSpaceSearch ignoring spaces and punctuation.
This option can only be used on the arrays of character strings.
WEBDEV - Browser code This constant is not available.
tccIgnoreSpaceSearch ignoring spaces at the beginning and end of strings.
This option can only be used on the arrays of character strings.
tccLexicographicOrderArray sorted according to the linguistic order.
This option is useful for a dichotomous search and it has no effect on a linear search.
This option can only be used on the arrays of character strings.
WEBDEV - Browser code This constant is not available.
tccRespectNumericArray sorted according to the order of numeric values.
This option is useful for a dichotomous search and it has no effect on a linear search.
This option can only be used on the arrays of character strings.
WEBDEV - Browser code This constant is not available.
AndroidAndroid Widget JavaPHP The constants used to define the search options are not available.
For a dichotomous search, the search options must be exactly the same as the options that were used to sort the array (see ArraySort).
<Sought value>: Any type
Value of element whose index is requested.
<Start index>: Optional integer
Start position for the search (linear search only). This parameter is not required for a binary search.
PHP Syntax not available in PHP

Seeking an element in a two-dimensional array of simple elements according to a column Hide the details

<Result> = Seek(<Array name> , <Type of search> , <Column> , <Sought value> [, <Start index>])
<Result>: Integer
  • Index of the sought element,
  • -1 if the element is not found in the array.
<Array name>: Array
Name of the Array variable to use. This array must be a two-dimensional array.
This array can also correspond to a two-dimensional array of an advanced type (sort an xlsDocument variable according to the values of a column for example).
<Type of search>: Integer constant
Search to perform:
asBinaryBinary search.
This search mode is fast but it must be used on an array sorted in ascending order, without duplicates (ArraySort used on the search column).
asLinearLinear search. The search starts:
  • from the first element.
  • from the value of the parameter <Start index>.
The search stops as soon as an element is found.
asLinearFirstLinear search from the first element. This constant must not be used if <Start index> is specified.
asLinearLastLinear search from the last element. This constant must not be used if <Start index> is specified.
asLinearNextLinear search for the next element. This search is performed from the current position or the value of <Start index>.
asLinearPreviousLinear search for the previous element. This search is performed from the current position or the value of <Start index>.
The type of search can be combined with one or more search options:
tccIgnoreAccentSearch ignoring accented characters.
This option can only be used on the arrays of character strings.
WEBDEV - Browser code This constant is not available.
tccIgnoreCaseSearch ignoring the case.
This option can only be used on the arrays of character strings.
tccIgnoreInsideSpaceSearch ignoring spaces inside strings.
This option can only be used on the arrays of character strings.
tccIgnorePonctuationAndSpaceSearch ignoring spaces and punctuation.
This option can only be used on the arrays of character strings.
tccIgnoreSpaceSearch ignoring spaces at the beginning and end of strings.
This option can only be used on the arrays of character strings.
tccLexicographicOrderArray sorted according to the linguistic order.
This option is useful for a dichotomous search and it has no effect on a linear search.
This option can only be used on the arrays of character strings.
WEBDEV - Browser code This constant is not available.
tccRespectNumericArray sorted according to the order of numeric values.
This option is useful for a dichotomous search and it has no effect on a linear search.
This option can only be used on the arrays of character strings.
WEBDEV - Browser code This constant is not available.
AndroidAndroid Widget Java The constants used to define the search options are not available.
For a dichotomous search, the search options must be exactly the same as the options that were used to sort the array (see ArraySort).
<Column>: Integer or character string
  • Simple array: Index of the column where the search will be performed.
  • Advanced array: Property for which the search must be performed. You also have the ability to use chained properties ("Border.Color" for example).
<Sought value>: Any type
Value of element whose subscript or property is requested.
<Start index>: Optional integer
Start position for the search (linear search only). This parameter is not required for a binary search.
PHP Syntax not available in PHP

Seeking an element in a two-dimensional array of simple elements according to several columns Hide the details

<Result> = Seek(<Array name> , <Type of search> , <Columns> , <Sought value 1> [, <Sought value 2> [... [, <Sought value N>]]] [, <Start index>])
<Result>: Integer
  • Index of the sought element,
  • -1 if the element is not found in the array.
<Array name>: Array
Name of the Array variable to use. This array must be a two-dimensional array.
This array can also correspond to a two-dimensional array of an advanced type (sort performed on a variable of type xlsDocument according to the values of one or more columns for example).
<Type of search>: Integer constant
Search to perform. No binary search is available.
asLinearLinear search. The search starts:
  • from the first element
  • from <Start subscript>
The search stops as soon as an element is found.
asLinearFirstLinear search from the first element. This constant must not be used if <Start index> is specified.
asLinearLastLinear search from the last element. This constant must not be used if <Start index> is specified.
asLinearNextLinear search for the next element. This search is performed from the current position or the value of <Start index>.
asLinearPreviousLinear search for the previous element. This search is performed from the current position or the value of <Start index>.
The type of search can be combined with one or more search options:
tccIgnoreAccentSearch ignoring accented characters.
This option is applied to all columns on which the search is performed.
This option is useful for the arrays of character strings.
WEBDEV - Browser code This constant is not available.
tccIgnoreCaseSearch ignoring the case.
This option is applied to all columns on which the search is performed.
This option is useful for the arrays of character strings.
tccIgnoreInsideSpaceSearch ignoring spaces inside strings.
This option is applied to all columns on which the search is performed.
This option is useful for the arrays of character strings.
tccIgnorePonctuationAndSpaceSearch ignoring spaces and punctuation.
This option is applied to all columns on which the search is performed.
This option is useful for the arrays of character strings.
WEBDEV - Browser code This constant is not available.
tccIgnoreSpaceSearch ignoring spaces at the beginning and end of strings.
This option is applied to all columns on which the search is performed.
This option is useful for the arrays of character strings.
tccLexicographicOrderArray sorted according to the linguistic order.
This option is useful for a dichotomous search and it has no effect on a linear search.
This option is applied to all columns on which the search is performed.
This option is useful for the arrays of character strings.
WEBDEV - Browser code This constant is not available.
tccRespectNumericArray sorted according to the order of numeric values.
This option is useful for a dichotomous search and it has no effect on a linear search.
This option is applied to all columns on which the search is performed.
This option is useful for the arrays of character strings.
WEBDEV - Browser code This constant is not available.
AndroidAndroid Widget Java The constants used to define the search options are not available.
For a dichotomous search, the search options must be exactly the same as the options that were used to sort the array (see ArraySort).
<Columns>: Character string
  • Simple array: List of columns where the search must be performed. The different columns must be separated by a semicolon. Example: "2;3" to perform a search on the columns 2 and 3.
  • Advanced array: List of properties where the search must be performed. The properties must be separated by a semicolon.
<Sought value 1>: Any type
Value of the element whose index or property is requested. A value must be indicated for each column or property specified in <Columns>.
<Sought value 2>: Any optional type
Value of the element whose index or property is requested. A value must be indicated for each column or property specified in <Columns>.
<Sought value N>: Any optional type
Value of the element whose index or property is requested. A value must be indicated for each column or property specified in <Columns>.
<Start index>: Optional integer
Start position for the search (linear search only). This parameter is not required for a binary search.

Seeking an element in a one-dimensional array of structures, classes, advanced types or records Hide the details

<Result> = Seek(<Array name> , <Type of search> , <Sought members> , <Sought value 1> [, <Sought value 2> [... [, <Sought value N>]]] [, <Start index>])
<Result>: Integer
  • Index of the sought element,
  • -1 if the element is not found in the array.
<Array name>: Array
Name of the Array variable to use. This array must be a one-dimensional array. This array can be:
  • an array of classes,
  • an array of structures,
    PHP No search can be performed in an array of structures.
  • an array of advanced types,
  • WINDEVWEBDEV - Server code an array of records.
<Type of search>: Integer constant
Type of search to perform:
asBinaryBinary search.
This search mode is fast but it must be used on an array sorted in ascending order, without duplicates (ArraySort).
This search mode can also be used when performing a search on a single member.
asLinearLinear search. The search starts:
  • from the first element
  • from <Start subscript>
The search stops as soon as an element is found.
asLinearFirstLinear search from the first element. This constant must not be used if <Start index> is specified.
asLinearLastLinear search from the last element. This constant must not be used if <Start index> is specified.
asLinearNextLinear search for the next element. This search is performed from the current position or the value of <Start index>.
asLinearPreviousLinear search for the previous element. This search is performed from the current position or the value of <Start index>.
The type of search can be combined with one or more search options:
tccIgnoreAccentSearch ignoring accented characters.
This option is applied to all members on which the search is performed.
This option is useful for the "character string" members.
WEBDEV - Browser code This constant is not available.
tccIgnoreCaseSearch ignoring the case.
This option is applied to all members on which the search is performed.
This option is useful for the "character string" members.
tccIgnoreInsideSpaceSearch ignoring spaces inside strings.
This option is applied to all members on which the search is performed.
This option is useful for the "character string" members.
tccIgnorePonctuationAndSpaceSearch ignoring spaces and punctuation.
This option is applied to all members on which the search is performed.
This option is useful for the "character string" members.
WEBDEV - Browser code This constant is not available.
tccIgnoreSpaceSearch ignoring spaces at the beginning and end of strings.
This option is applied to all members on which the search is performed.
This option is useful for the "character string" members.
tccLexicographicOrderArray sorted according to the linguistic order.
This option is useful for a dichotomous search and it has no effect on a linear search.
This option is applied to all members on which the search is performed.
This option is useful for the "character string" members.
WEBDEV - Browser code This constant is not available.
tccRespectNumericArray sorted according to the order of numeric values.
This option is useful for a dichotomous search and it has no effect on a linear search.
This option is applied to all members on which the search is performed.
This option is useful for the "character string" members.
WEBDEV - Browser code This constant is not available.
AndroidAndroid Widget JavaPHP The constants used to define the search options are not available.
For a dichotomous search, the search options must be exactly the same as the options that were used to sort the array (see ArraySort).
<Sought members>: Character string
  • Structures and classes: Name of sought members. If several members are sought, their names must be separated by a semicolon. You also have the ability to chain the sought members (by using "." or ":" between the members). In a class, you also have the ability to perform a search on the class properties.
  • Advanced types: Name of sought properties. If several properties are sought, their names must be separated by a semicolon. You also have the ability to chain the sought properties (by using "." or ":" between the properties). For example, "Border.Color".
  • Records: Name of sought items. If several items are sought, their names must be separated by a semicolon. You also have the ability to chain the sought items (by using "." or ":" between the properties).
<Sought value 1>: Any type
Value of element whose member or property is requested. A value must be indicated for each member specified in <Sought members>.
<Sought value 2>: Any optional type
Value of element whose member or property is requested. A value must be indicated for each member specified in <Sought members>.
<Sought value N>: Any optional type
Value of element whose member or property is requested. A value must be indicated for each member specified in <Sought members>.
<Start index>: Optional integer
Start position for the search (linear search only). This parameter is not required for a binary search.

Searching for the index of an object in a one-dimensional array (syntax for the data binding) Hide the details

<Result> = Seek(<Array name> , <Type of search> , <Sought object>)
<Result>: Integer
  • Index of the sought object,
  • -1 if the object is not found in the array.
<Array name>: Array
Name of the Array variable to use. This array must be a one-dimensional array. This array can be an array of classes, dynamic classes, structures, dynamic structures, advanced types, dynamic advanced types.
<Type of search>: Integer constant
Type of search to perform:
asLinearLinear search.
<Sought object>: Any type
Instance of sought object.
Remarks
  • This function cannot be used on the fixed arrays.
  • This function can be used on the arrays of advanced variables.
  • This function cannot be used on the array of "Dynamic objects".
  • This function can be used on the arrays of typed objects.
    • For example, no search can be performed in the following array:
      t is array of 2 objects dynamic
    • For example, a search can be performed in the following array:
      t is array of 2 MyClass

      t is array of 2 MyClass dynamic
  • No search can be performed on an array of variants.
  • No search can be performed on the Unicode strings.
    AndroidAndroid Widget Java If the type of the search is dichotomous and if the array is not sorted, no WLanguage error will be displayed but the result of the search will be undefined.
Component: wd290vm.dll
Minimum version required
  • Version 14
This page is also available for…
Comments
Exemplo Seek
//Vou ensinar como Procurar um valor dentro array

tabListanumeros is array of 0 int
ArrayAddLine(tabListanumeros,10)
ArrayAddLine(tabListanumeros,5)
ArrayAddLine(tabListanumeros,3)
ArrayAddLine(tabListanumeros,1)
//Coloca Array numa String

EDT_Texto = ArrayToString(tabListanumeros)

n_procura is int=Seek(tabListanumeros, asLinearFirst, EDT_PROCURA)
IF n_procura=-1 THEN
EDT_resultado="Nao Achou"
ELSE
EDT_resultado="Achou"
END

// Blog com Video e Exemplo
http://windevdesenvolvimento.blogspot.com.br/2016/12/aula-993-windev-array-005-seek.html
https://www.youtube.com/watch?v=Q5yuh3bu8J8
De matos
13 Dec. 2016

Last update: 04/06/2023

Send a report | Local help