TableSearchChild (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Type of search
Miscellaneous

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

TableSearchChild (Function)

In french: TableChercheFils

Warning
From version 27, TableSeekChild is kept for backward compatibility. This function is replaced by TableSearchChild.

Searches for a value in a column of a TreeView Table control, in a specified branch.

Versions 18 and later

This function is now available for PHP sites.

This function is now available for WEBDEV sites in Windows.

This function is now available for WEBDEV sites in Linux.

New in version 18

This function is now available for PHP sites.

This function is now available for WEBDEV sites in Windows.

This function is now available for WEBDEV sites in Linux.

This function is now available for PHP sites.

This function is now available for WEBDEV sites in Windows.

This function is now available for WEBDEV sites in Linux.

Versions 27 and later

This function is now available for Android applications.

This function is now available for iPhone/iPad applications.

New in version 27

This function is now available for Android applications.

This function is now available for iPhone/iPad applications.

This function is now available for Android applications.

This function is now available for iPhone/iPad applications.

Example

// Searches for the "Shirt" element in the "COL_Product" column
// Generic search in the rows of level 2
ResSearch = TableSearchChild(COL_Product, "Shirt", False, 2)

Syntax

Searching for a value by the index of the parent element Hide the details

<Result> = TableSearchChild(<Column> , <Search element> [, <Type of search> [, <Index of the parent element> [, <Source row>]]])

<Result>: Integer

Index of the element found,
-1 if no element corresponds to the search.

<Column>: Control name

Name of the column in which the search will be performed.

<Search element>: Type of search element

Element to be found in the specified column. If the type of the search element is:
"Date" or "Time": the search is performed on the returned value.
"Currency + Euro": the search is performed on the stored currency.

<Type of search>: Optional boolean

True (default value) if the search must be an exact-match search,
False if the search must be a generic search.

<Index of the parent element>: Optional integer

Index of the parent row in the hierarchy.

<Source row>: Optional integer

Number of the source row for the search. If this parameter is not specified, the search is performed in the entire column. This parameter is used to find all the occurrences of a string in a column.

Searching for a value by specifying the parent element Hide the details

<Result> = TableSearchChild(<Column> , <Search element> [, <Type of search> [, <Parent element> [, <Source row>]]])

<Result>: Integer

Index of the element found,
-1 if no element corresponds to the search.

<Column>: Control name

Name of the column in which the search will be performed.

<Search element>: Type of search element

Element to be found in the specified column. If the type of the search element is:
"Date" or "Time": the search is performed on the returned value.
"Currency + Euro": the search is performed on the stored currency.

<Type of search>: Optional boolean

True (default value) if the search must be an exact-match search,
False if the search must be a generic search.

<Parent element>: Optional integer

Content of the parent row in the hierarchy. This parameter corresponds to NULL by default: used to perform a search among the roots.

<Source row>: Optional integer

Number of the source row for the search. If this parameter is not specified, the search is performed in the entire column. This parameter is used to find all the occurrences of a string in a column.

Remarks

Type of search

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

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

// Return all customers whose name starts with "SMI"
TableSearchChild(COL_Name, "SMI", False)

Miscellaneous

The element found is not selected. TablePosition is used to position on the row and TableSelectPlus is used to select the row.
The search performed by TableSearchChild is not case sensitive (uppercase/lowercase characters).

Business / UI classification: UI Code

Component: wd270obj.dll