PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
This content has been translated automatically. Click here to view the French version.
  • Overview
  • Describing the Table control
  • "Use HFilter to browse the file" option unchecked
  • "Use HFilter to browse the file" option checked
  • Filter property
  • HFilter
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
Overview
WINDEV, WEBDEV and WINDEV Mobile propose several methods to filter the records displayed in a browsing Table control:
Describing the Table control
The option "Display the records whose search key starts with" is used to describe a filter on a browsing Table control.
The filter has the following characteristics:
  • "Starts with" filter. The condition is directly entered in the editor.
  • The filter is only applied to browsing Table controls.
  • The filter does not affect how the data file is browsed (HReadFirst, etc.)
WindowsHFSQLHFSQL Client/ServerHyper File 5.5OLE DBODBCNative Connectors (Native Accesses)

"Use HFilter to browse the file" option unchecked

If the option "Use HFilter to browse the file" is unchecked, the filter has the following characteristics:
  • "Starts with" filter. The condition is directly entered in the editor.
  • The filter is only applied to browsing Table controls.
  • The filter does not affect how the data file is browsed (HReadFirst, etc.)
  • Only the column associated with the search item can be sorted ("Sortable" option in the "General" tab).
  • No search can be performed by the user in the Table control ("Searchable" option in the "General" tab).
WindowsHFSQLHFSQL Client/ServerHyper File 5.5OLE DBODBCNative Connectors (Native Accesses)

"Use HFilter to browse the file" option checked

If the option "Use HFilter to browse the file" is checked, the filter has the following characteristics:
  • "Starts with" filter. The condition is directly entered in the editor.
  • The filter is only applied to browsing Table controls.
  • The filter does not affect how the data file is browsed (HReadFirst, etc.)
  • The user will be able to sort the information displayed in the columns bound to with key items ("Sortable" option in the "General" tab).
  • The user will be able to perform searches in the columns bound to key items ("Searchable" option in the "General" tab).
Special case: Before opening the Table control window, a filter was defined by the HFilter function on the control base file. The Table control automatically filters the displayed records (filter set directly in the editor or with the Filter property). When the closing window, no filter will be enabled on the data file.
Caution: Check which filter is active when browsing the files. Since two filters cannot be activated simultaneously, only the last filter created with the HFilter function is retained.
Filter property
The Property Filter allows to dynamically set the characteristics of the filter applied to the Table control .
HFilter
The HFilter function is used to filter the Table control base file. HFilter allows you to use all types of filters (including the "Starts with" filters).
If function HFilter is not used in the initialization code of Table control, it is necessary to redisplay the contents of Table control with function TableDisplay.
Remark: When a browsing Table control is automatically filled (by WINDEV, WEBDEV or WINDEV Mobile), the Table control is not filled when running the initialization code. The records can be filtered by HFilter.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment