PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
FilteredItem (Property)
In french: RubriqueFiltrée
ODBCNot available with this kind of connection
..FilteredItem is used to find out the item on which a filter was implemented by HFilter. This property can be used on a HFSQL data file, view or query.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Example
// Enables the filter
HFilter(Customer, CustomerName, "D" + hValMin, "F" + hValMax, "City='Paris'")
Trace(Customer..FilteredItem)  // Indicates "CustomerName"

// Disables the filter
HDeactivateFilter(Customer)
Syntax
<Item> = <Element name>..FilteredItem
<Item>: Character string
  • Item onto which the filter defined by HFilter is applied,
  • Empty string ("") if no filter is enabled.
<Element name>: Character string (with or without quotes)
Name of the HFSQL data file, query or view on which the filter was defined.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment