PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

  • Values of bounds
  • Reminder: hMinVal and hMaxVal used in a filter
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
FilterWithBounds (Property)
In french: FiltreAvecBornes
ODBCNot available with this kind of connection
..FilterWithBounds is used to find out whether bounds have been specified for the filter implemented by HFilter on a HFSQL data file, view or query.
Versions 17 and later
iPhone/iPad This property is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This property is now available for the iPhone/iPad applications.
iPhone/iPad This property is now available for the iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This property is now available in Windows Store Apps mode.
New in version 18
Universal Windows 10 App This property is now available in Windows Store Apps mode.
Universal Windows 10 App This property is now available in Windows Store Apps mode.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 21 and later
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Example
// Enables the filter
HFilter(Customer, CustomerName, "D" + hValMin, "F" + hValMax, "City='Paris'")
IF Customer..FilterWithBounds = True THEN Trace("Bounds have been defined for the filter")
// Disables the filter
HDeactivateFilter(Customer)
Syntax
<Result> = <Element name>..FilterWithBounds
<Result>: Boolean
  • True if bounds have been specified for the filter with HFilter,
  • False otherwise.
<Element name>: Character string (with or without quotes)
Name of the HFSQL data file, query or view on which the filter was defined.
Remarks

Values of bounds

If bounds have been defined, their values are returned by ..MinValue and ..MaxValue.

Reminder: hMinVal and hMaxVal used in a filter

To implement a generic filter on a value, you must:
  • fill the lower bound with the hMinVal constant to give it the minimum value.
  • fill the upper bound with the hMaxVal constant to give it the maximum value.
For example, to select the customers whose last name starts with "Dupon":
HFilter(Customer, Name, "Smith" + hMinVal, "Smith" + hMaxVal)
The customers named "Smith" and "Smither" are selected.
See the help about HFilter for more details.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment