PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
New WINDEV, WEBDEV, WINDEV Mobile 25 feature!
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
<Source>.ActivateAutoFilter (Function)
In french: <Source>.ActiveFiltreAuto
Native Connectors (Native Accesses)Available 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 <Source>.DeactivateAutoFilter.
Caution: This function is only available for the Native XML Connector.
Versions 17 and later
iPhone/iPad This function is now available for iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for iPhone/iPad applications.
iPhone/iPad This function is now available for 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.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Example
// Enable all the possible automatic filters on the CUSTOMER data file
Customer.ActivateAutoFilter("*" )
// except between Customer and Order data files
Customer.DeactivateAutoFilter(Order)
 
/////////////////////////////
 
// Browse orders
Order.ReadFirst(ORDERID)
WHILE NOT Order.Out()
// Browse order lines of current order
OrdLine.ReadFirst(ORDERID)
WHILE NOT OrdLine.Out()
OrdLine.ReadNext(ORDERID)
END
// Next order
Order.ReadNext(ORDERID)
END
Syntax
<Result> = <Browse data file>.ActivateAutoFilter(<Data file to filter>)
<Result>: Boolean
  • True if the filter is enabled,
  • False if an error occurred (file or item not found).
<Browse data file>: Name of data file
Name of the data file used for the browse.
<Data file to filter>: Name of data file
Name of the data file to filter when positioned in the browse data file.
This parameter can correspond to "*". In this case, all the possible automatic filters will be enabled.
Remarks
Let's see a simple example:
Parent.ActivateAutoFilter(Child)

This code indicates that the records in the Child data file are browsed according to the current 'context' (node) of the Parent data file: all 'Child' of the current 'Parent' will be browsed.

Parent.DeactivateAutoFilter(Child)

This code indicates that the previous filter is not enabled: The Child data file will be browsed independently of Parent. This means that all the records of Child will be browsed in the given child.
<Source>.ActivateAutoFilter is used to enable/disable the hierarchical link between Parent and Child during browse operations.
Component : wd250hf.dll
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment