PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Effect of the function
  • Use conditions
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
Switches to input mode the search area found in the column title of the Table or Treeview Table control .
  • WINDEV In WINDEV:
  • Versions 20 and later
    Android In Android:
    New in version 20
    Android In Android:
    Android In Android:
This function has the same effect as a click performed by the user on the icon representing a magnifier. It can start a search or implement a filter on the control.
To cancel a filter started by TableInputSearch, all you have to do is use TableDisableFilter.
Note: This function is ignored if the specified Table control is using a non-proportional scrollbar ("Proportional scrollbar" unchecked in the "Details" tab of the description window of the control). See Characteristics of table columns for more details.
Versions 19 and later
WEBDEV - Browser code This function is now available in Browser code for the Browser Table controls.
New in version 19
WEBDEV - Browser code This function is now available in Browser code for the Browser Table controls.
WEBDEV - Browser code This function is now available in Browser code for the Browser Table controls.
Versions 20 and later
Android This function is now available for the Android applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 20
Android This function is now available for the Android applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Android This function is now available for the Android applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Example
// Switches the COL_Date column of TABLE_TABLE1 to edit mode
TableInputSearch(TABLE_TABLE1.COL_DATE)
// Switches the COL_Name column to edit mode
TableInputSearch(COL_NAME)
Syntax
TableInputSearch(<Column Name> [, <Type of Filter or Search> [, <Initial Value>]])
<Column Name>: Character string (with or without quotes)
Name of column that will be switched to search mode. The function has no effect if this operation cannot be performed on this column (non-key column for example).
The name of the column can be given directly or in the following format: <Table Name>.<Column Name>.
Java The column used must be a "Searchable" column ("General" tab of the column description).
<Type of Filter or Search>: Optional Integer constant
Type of filter to apply or type of search to perform:
filterStartsWithDisplays the rows whose value for the specified column "Starts with" the characters specified in <Initial Value>.
filterContainsDisplays the rows whose value for the specified column "Contains" the characters specified in <Initial Value>.
filterDifferentDisplays the rows whose value for the specified column "differs" from the characters specified in <Initial Value>.
filterEqualDisplays the rows whose value for the specified column "is equal" to the characters specified in <Initial Value>.
filterLessOrEqualDisplays the rows whose value for the specified column "is less than or equal to" the characters specified in <Initial Value>.
filterLessDisplays the rows whose value for the specified column "is less" than the characters specified in <Initial Value>.
filterDoesNotStartWithDisplays the rows whose value for the specified column "Does not start with" the characters specified in <Initial Value>.
filterDoesNotContainDisplays the rows whose value for the specified column "does not contain" the characters specified in <Initial Value>.
filterDoesNotEndWithDisplays the rows whose value for the specified column "does not end with" the characters specified in <Initial Value>.
filterGreaterOrEqualDisplays the rows whose value for the specified column "is greater than or equal to" the characters specified in <Initial Value>.
filterGreaterDisplays the rows whose value for the specified column "is greater" than the characters specified in <Initial Value>.
filterEndsWithDisplays the rows whose value for the specified column "ends with" the characters specified in <Initial Value>.
searchStartsWithSorts the table according to the specified column, switches the column to search mode and fills the edit control of the column with the characters specified in <Initial Value>. Displays the rows from the ones for which the value of the specified column "starts with" the characters specified in <Initial Value>.
searchDefault
(Default value)
Sorts the table according to the specified column and switches the column to search mode.
AndroidiPhone/iPadJava This parameter is not available.
<Initial Value>: Optional character string (with quotes)
Initial value that must be specified in the input area of search mode.
AndroidiPhone/iPadJava This parameter is not available.
Remarks

Effect of the function

This function will have no effect if the switch to search mode cannot be performed. For example, the search mode will not be enabled:
  • If the column was not defined as column with search (description window of the control).
  • If the column is not associated with a key item.

Use conditions

This function is available for a memory or browsing control.
WEBDEV - Browser code This function is available for the browser Table controls only.
WEBDEV - Browser codeAndroidiPhone/iPad The TreeView Table control is not available.
Components
WINDEVReports and Queries wd230obj.dll
Windows Mobile wp230obj.dll
WEBDEV - Browser code WDJS.DLL
Java wd230java.jar
Android wd230android.jar
Minimum required version
  • Version 9
This page is also available for…
Comments
Small note
the TableInputSearch(MyTable.MyColumn, ...) function opens the search-field above the column but doesn't show the cursor.

TableInputSearch(MyTable.MyColumn,SearchDefault)
ReturnToCapture(MyTable.MyColumn)

will cure that and enable users to input a search value without having to click the search field first.
Guenter
Jul. 12 2017
Exemplo TableInputSearch
TableInputSearch(TABLE_Cliente.COL_Nome,filterContains)
TableInputSearch(TABLE_Cliente.COL_ClienteID)
//Frances
TableInputSearch(TABLE_Cliente.COL_Nome,filtreContient)

//Blog Com Video e Exemplo
http://windevdesenvolvimento.blogspot.com.br/2016/03/curso-windev-tabela-019-tableinputsearch.html
De matos AMARILDO
Mar. 22 2016