ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage properties / HFSQL properties
  • 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/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
FilterWithBounds (Property)
In french: FiltreAvecBornes
ODBCNot available with this kind of connection
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.
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 used>.FilterWithBounds
<Result>: Boolean
  • True if bounds have been specified for the filter with HFilter,
  • False otherwise.
<Element used>: Character string
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 "Smith":
HFilter(Customer, Name, "Smith" + hMinVal, "Smith" + hMaxVal)
The customers named "Smith" and "Smither" are selected.
For more details, see the help about HFilter.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help