|
|
|
|
|
|
|
|
|
|
- Filter
- Filtered browse
- Enabling/Disabling a filter
HFilterContains (Function) In french: HFiltreContient
 Available only with this kind of connection
Defines and enables a "Contains" filter on a data file, view or query. The "Contains" filter is used to select all the records containing a specific set of characters. This filter is not case sensitive. This filter does not use any index, it browses the entire data file.
CléParcours is string = HFilterContains(Client, Commentaire, "VIP")
HReadFirst(Client, CléParcours)
WHILE NOT HOut()
Trace(Client.NomClient, Client.Ville)
HReadNext(Client, CléParcours)
END
HDeactivateFilter(Client)
Syntax
<Result> = HFilterContains(<Data file> , <Item> , <Value>)
<Result>: Character string Browse item. Corresponds to: - the name of item used to loop through the data file if the filter is enabled,
- an empty string ("") if the filter cannot be implemented.
<Data file>: Character string Name of the HFSQL data file, view or query used. <Item>: Character string Name of item on which the filter will be implemented. This item can be a key item or a non-key item. <Value>: Character string Value that must be found in the record item. Remarks Filter - The filter is enabled as soon as HFilterContains is called.
- Equivalent syntaxes:
HFilterContains(NomFichier, NomRubrique, "Valeur")
is equivalent to:
HFilter(NomFichier, "NomRubrique ~]'Valeur'")
Filtered browse When a filter is defined and enabled on a data file, any record read corresponds to the filter. If no other record corresponds to the filter during the iteration: - HOut returns True.
- the current record corresponds to the last record read with the filter.
For example: | | | On a filtered data file, after the function: | the current record is: |
|---|
| HReadFirst | the first file record corresponding to the filter. | | HReadLast | the last file record corresponding to the filter. | | HReadNext (or HForward) | the next record (or the next nth record) corresponding to the filter. | | HReadPrevious (or HBackward) | the previous record (or the previous nth record) corresponding to the filter. |
Enabling/Disabling a filter - HDeactivateFilter is used to disable a filter.
- HActivateFilter is used to re-enable a filter.
- The filter is deleted when the data file (query or view) is closed (HClose or HOpenAnalysis for example).
- A single filter can exist at a given time on a data file (query or view). If the HFilterContains is used several times, only the last filter will be taken into account: the previous filter(s) will be deleted. Similarly, if several filters are used (HFilter* functions), only the last filter will be taken into account.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|