PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

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
HActivateAutoFilter (Function)
In French: HActiveFiltreAuto
Native AccessesAvailable only with this kind of connection
Enables an automatic filter on the linked data files when browsing an XML file. This filter can be disabled by HDeactivateAutoFilter.
Caution: This function is available for the Native XML Access only.
Versions 17 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for the iPhone/iPad applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Example
// Enable all the possible automatic filters of CUSTOMER file
HActivateAutoFilter(CUSTOMER, "*" )
// except between CUSTOMER and ORDER
HDeactivateAutoFilter(CUSTOMER, ORDER)

/////////////////////////////

// Browse the orders
HReadFirst(ORDER, ORDERID)
WHILE NOT HOut()
// Browses the order lines of the current order
HReadFirst(ORDLINE, ORDERID)
WHILE NOT HOut()
HReadNext(ORDLINE, ORDERID)
END
// Next order
HReadNext(ORDER, ORDERID)
END
Syntax
<Result> = HActivateAutoFilter(<Name of Browse File> , <Name of File to Filter>)
<Result>: Boolean
  • True if the filter is enabled,
  • False if an error occurred (file or item not found).
<Name of Browse File>: Character string (with or without quotes)
Name of the data file used for the browse.
This parameter can correspond to "*". In this case, all the possible automatic filters will be enabled.
If <Name of Browse File> and <Name of File to Filter> correspond to "*", <Result> is set to True and no filter is enabled.
<Name of File to Filter>: Character string (with or without quotes)
Name of the data file to filter during a positioning in the browse file.
This parameter can correspond to "*". In this case, all the possible automatic filters will be enabled.
If <Name of Browse File> and <Name of File to Filter> correspond to "*", <Result> is set to True and no filter is enabled.
Remarks
Let's see a simple example:
HActivateAutoFilter(PARENT, CHILD)
This code indicates that when the records found in the CHILD file are browsed, this browse is performed according to the current 'context' (node) of PARENT: all the 'CHILD' elements of the current PARENT will be browsed.
HDeactivateAutoFilter(PARENT, CHILD)
This code indicates that the previous filter is not enabled: CHILD will be browsed independently of PARENT. Which means that all the records of CHILD will be browsed in the given child element.
HActivateAutoFilter is used to enable/disable the hierarchical link between PARENT and CHILD during the browse operations.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Linux wd230hf.so
Windows Mobile wp230hf.dll
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment