PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Type of Search
  • Various
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
TableSeekChild (Function)
In French: TableChercheFils
Seeks 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 the PHP sites.
WEBDEV - Server codeWindows This function is now available for the WEBDEV sites in Windows.
WEBDEV - Server codeLinux This function is now available for the WEBDEV sites in Linux.
New in version 18
WEBDEV - Server codePHP This function is now available for the PHP sites.
WEBDEV - Server codeWindows This function is now available for the WEBDEV sites in Windows.
WEBDEV - Server codeLinux This function is now available for the WEBDEV sites in Linux.
WEBDEV - Server codePHP This function is now available for the PHP sites.
WEBDEV - Server codeWindows This function is now available for the WEBDEV sites in Windows.
WEBDEV - Server codeLinux This function is now available for the WEBDEV sites in Linux.
Example
// Finds the "Shirt" element in the "COL_Product" column
// Generic search in the rows of level 2
ResSearch = TableSeekChild(COL_Product, "Shirt", False, 2)
Syntax

Search while specifying the subscript of parent element Hide the details

<Result> = TableSeekChild(<Column Name> , <Sought Element> [, <Type of Search> [, <Subscript of Parent Element> [, <Source Row>]]])
<Result>: Integer
  • Subscript of element found,
  • -1 if no element corresponds to the search.
<Column Name>: Character string (with or without quotes)
Name of column where the search will be performed.
<Sought Element>: Type of sought element
Element that must be found in the specified column. If the type of the sought 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.
<Subscript of Parent Element>: Optional integer
Subscript 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.

Search while specifying the parent element Hide the details

<Result> = TableSeekChild(<Column Name> , <Sought Element> [, <Type of Search> [, <Parent Element> [, <Source Row>]]])
<Result>: Integer
  • Subscript of element found,
  • -1 if no element corresponds to the search.
<Column Name>: Character string (with or without quotes)
Name of column where the search will be performed.
<Sought Element>: Type of sought element
Element that must be found in the specified column. If the type of the sought 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 <Sought Element> are returned by TableSeekChild. For example:
    // Return all the customers named "Doe" found in "COL_Name"
    TableSeekChild(COL_Name, "Doe")
  • Generic search: The elements starting with <Sought Element> are returned by TableSeekChild. For example:
    // Return all customers whose name starts with "SMI"
    TableSeekChild(COL_Name, "SMI", False)

Various

  • 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 TableSeekChild is not case sensitive (uppercase/lowercase characters).
Components
WINDEVReports and Queries wd230obj.dll
WEBDEV - Server code wd230page.dll
Windows Mobile wp230obj.dll
Java wd230java.jar
Linux wd230obj.so
Minimum required version
  • Version 12
This page is also available for…
Comments
Click [Add] to post a comment