|
|
|
|
|
|
|
|
|
|
- Filter property and Table controls based on a data file
- Manipulation of Table, List, Image List, Combo and RepeatString fields using file properties
- Modifying the properties used to loop through a Table, List Box, ListView, Combo Box or Looper control based on a data file
- Limit
Filter (Property) In french: Filtre
The Filter property is used to identify and change the filter applied to records in: - Table controls based on a data file,
- browsing TreeView Table controls,
- List Box controls based on a data file,
- Combo Box controls based on a data file,
- Looper controls based on a data file.
This filter (if it exists) can be defined during the control description ("Content" tab).
This filter (property Filter or filter entered in the editor) has the following characteristics: - "Starts with" filter.
- applies to the search item only.
- affects the object used (Table, Combo Box, List Box or ListView control)
- does not affect the data file on which the object is based (except for the Table controls based on a data file, see below).
Remarks: - To use a filter on a composite key, use HFilter.
- The Filter property cannot be used to identify filters defined by the user (with the TableEnableFilter function, for example).
COMBO_Elément.Filtre = COMBO_Elément
IF TABLE_Client.Filtre = "" THEN
TABLE_Client.Filtre = "PARIS"
END
Syntax
Finding out the filter defined on the search item Hide the details
<Filter value> = <Control used>.Filter
<Filter value>: Type of filter Current value of filter defined on the search item. This filter is a "Start with" filter. <Control used>: Control name Name of the field for which you want to know the current filter: this filter has been defined either by the Filterproperty, or directly in the window or page editor (in the field description).. The type of this control must be: - List or List image file,
- File combo,
- browsing Table or TreeView Table,
- Looper based on a data file.
Modifying the filter defined on the search item Hide the details
<Control used>.Filter = <New filter value>
<Control used>: Control name Name of control whose current filter will be modified. The type of this control must be: - List or List image file,
- File combo,
- browsing Table or TreeView Table,
- Looper based on a data file.
<New filter value>: Type of filter - New value for the filter defined on the search key,
- Empty string ("") for no filter.
Remarks Filter property and Table controls based on a data file For Table controls based on a data file, the Check Box "Use HFilter to browse the file" is used to keep the search and sort options on the filtered columns (magnifier, etc.). If "Use HFilter to browse the file" is checked: - the property is not applied to the Table control only but it is also applied to the data file onto which the control is based. Therefore, a browse performed on the base file of the control will be filtered.
- A filter (HFilter) is automatically applied to the data file onto which the Table control is based.
- If a filter is defined on the data file (HFilter) BEFORE displaying the Table control (TableDisplay for example), only the filter of the Table control will be taken into account. Then, the data file will be browsed according to the filter of the Table control.
Manipulation of Table, List, Image List, Combo and RepeatString fields using file properties - The records displayed in a List Box, Table, Combo Box or Looper control based on a data file come from the data file or query specified with the BrowsedFile property.
- The sort direction is defined by the BrowsedItem property.
- The records can be filtered using the Filter property or the HFilter function. Warning: the Filter property only allows "Starts with" filtering on the route key.
Modifying the properties used to loop through a Table, List Box, ListView, Combo Box or Looper control based on a data file - Stop the iteration by assigning an empty string ("") to the BrowsedFile property.
- Change the relevant properties.
- Restart the iteration with the BrowsedFile property.
This method is used to optimize the modifications performed. Each one of the modifications made individually restarts the iteration. These operations can become quite slow when they are performed on large files. Limit The Filter property applies only to controls in a window or page. This property applies only to the following controls: - List Box control based on a data file,
- List Box control based on a data file,
- Browsing Combo Box control,
- Table based on a data file field,
- Looper control RepeatString file field,
- Browsing TreeView Table control.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|