- Type of search
- Miscellaneous
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.
// 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
This page is also available for…
|
|
|
|