ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

HFSQL: Change of name
FilterWithBounds (Property)
The FilterWithBounds property is used to determine if bounds have been specified for the filter implemented by HFilter on an HFSQL data file, view or query.
Filtering a data file, a view or a query
A filter is used to define by programming a selection of records corresponding to one or more criteria......
How to create an SQL query to filter records?
This help page explains how to create an SQL query to filter records....
How to loop through a file using filters?
Filters in Table controls based on a data file
WINDEV, WEBDEV and WINDEV Mobile include multiple methods to filter the records displayed in a Table control based on a data file......
Translating the interface into multiple languages
When the different languages supported by the application have been selected, the information displayed by the application must be translated into these different languages......
FilteredItem (Property)
The FilteredItem property is used to identify the item that has a filter implemented by HFilter.
HBuildKeyValue (Function)
Builds the value of a composite key to implement a filter (HFilter) or to perform a search (HReadSeekFirst, HReadSeekLast, etc.).
<Source>.DeactivateFilter (Function)
Temporarily disables the filter on a data file (view or query).
<Source>.Filter (Function)
Defines and enables a filter on a data file, view or query.
<Source>.BuildKeyValue (Function)
Builds the value of a composite key to implement a filter (HFilter) or to perform a search (HReadSeekFirst, HReadSeekLast, etc.).
<Source>.FilterStartsWith (Function)
Defines and enables a "Start with" filter on a file, view or query.
<Source>.FilterIncludedBetween (Function)
Defines and enables an "Included between" filter on a file, view or query.
HFilter (Function)
Defines and enables a filter on a data file, view or query.
HFilterStartsWith (Function)
Defines and enables a "Start with" filter on a file, view or query.
HFilterIncludedBetween (Function)
Defines and enables an "Included between" filter on a file, view or query.
HDeactivateFilter (Function)
Temporarily disables the filter on a data file (view or query).
<Source>.ActivateAutoFilter (Function)
Enables an automatic filter on the linked files when browsing an XML file.
<Source>.DeactivateAutoFilter (Function)
Disables an automatic filter on the linked files when browsing an XML file.
<Source>.SavePosition (Function)
Stores the current file context: current record, filter, pointers.
<Source>.FilterContains (Function)
Defines and enables a "Contains" filter on a data file, view or query.
HActivateAutoFilter (Function)
Enables an automatic filter on the linked files when browsing an XML file.
HSavePosition (Function)
Stores the current file context: current record, filter, pointers.
HFilterContains (Function)
Defines and enables a "Contains" filter on a data file, view or query.