FilterWithBounds (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Reminder: hMinVal and hMaxVal used in a filter

InfoThumbnailGeneration

OperationLogDirectory

Password

PasswordProtected

PersistedCalculatedItem

RepeatableReadSupported

This content has been translated automatically. Click here to view the French version.

Values of bounds
Reminder: hMinVal and hMaxVal used in a filter

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

FilterWithBounds (Property)

In french: FiltreAvecBornes

Not available with this kind of connection

The Property FilterWithTerminals allows to know if terminals have been specified on the filter set up by the HFilter function on a data file, a HFSQL view or a query.

Versions 17 and later

This property is now available for iPhone/iPad applications.

New in version 17

This property is now available for iPhone/iPad applications.

Versions 18 and later

This property is now available in Windows Store apps mode.

New in version 18

This property is now available in Windows Store apps mode.

Remark: From version 19, HFSQL is the new name of HyperFileSQL.

Versions 21 and later

This property is now available in Universal Windows 10 App mode.

New in version 21

This property is now available in Universal Windows 10 App mode.

Example

// Enables the filter
HFilter(Customer, CustomerName, "D" + hMinVal, "F" + hMaxVal, "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 (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 "Smith":

HFilter(Customer, Name, "Smith" + hMinVal, "Smith" + hMaxVal)

The customers named "Smith" and "Smither" are selected.

For more details, see the help about HFilter.