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
FilterCondition (Property)
In french: ConditionFiltre
ODBCNot available with this kind of connection
..FilterCondition is used to find out the selection condition implemented by HFilter on a HFSQL data file, view or query.
Versions 18 and later
Universal Windows 10 App This property is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This property is now available in Windows Store apps mode.
Universal Windows 10 App 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
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Universal Windows 10 App This property is now available in Universal Windows 10 App mode.
Example
// Enable the filter
HFilter(Customer, CustomerName, "D" + hMinVal, "F" + hMaxVal, "City='Paris'")
// Insert your process here
Trace(Customer..MaxValue)
Trace(Customer..MinValue)
Trace(Customer..FilterCondition) // Specifies "City=Paris"

// Disable the filter
HDeactivateFilter(Customer)
Syntax
<Selection condition> = <Element used>..FilterCondition
<Selection condition>: Character string
  • Condition specified by HFilter,
  • Empty string ("") if no filter is enabled or if no selection condition was specified.
This selection condition can be an Ansi or Unicode character string.
<Element used>: 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