|
|
|
|
- Values of bounds
- Reminder: hMinVal and hMaxVal used in a filter
FilterWithBounds (Property) In french: FiltreAvecBornes
Not 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.
// 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.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|