PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
  • Type of search
  • Miscellaneous
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
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
WEBDEV - Server codePHP This function is now available for PHP sites.
WEBDEV - Server codeWindows This function is now available for WEBDEV sites in Windows.
WEBDEV - Server codeLinux This function is now available for WEBDEV sites in Linux.
New in version 18
WEBDEV - Server codePHP This function is now available for PHP sites.
WEBDEV - Server codeWindows This function is now available for WEBDEV sites in Windows.
WEBDEV - Server codeLinux This function is now available for WEBDEV sites in Linux.
WEBDEV - Server codePHP This function is now available for PHP sites.
WEBDEV - Server codeWindows This function is now available for WEBDEV sites in Windows.
WEBDEV - Server codeLinux This function is now available for WEBDEV sites in Linux.
Versions 27 and later
Android This function is now available for Android applications.
iPhone/iPad This function is now available for iPhone/iPad applications.
New in version 27
Android This function is now available for Android applications.
iPhone/iPad This function is now available for iPhone/iPad applications.
Android This function is now available for Android applications.
iPhone/iPad 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
Minimum version required
  • Version 12
This page is also available for…
Comments
Click [Add] to post a comment