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.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
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 name>..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 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