PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • Automatic management of composite keys
  • Filter and filtered browse
  • Enabling/Disabling a filter
  • Data file not in HFSQL format
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
Defines and enables a filter used to find the exact value of a string item. This filter can be used on a data file, a view or a query.
After its execution, the most common cases are as follows:
  • the filter cannot be created: HFilterIdentical returns an empty string (""). HError returns the error identifier.
  • the filter is created: HFilterIdentical returns the optimized search key that will be used to browse the data file, view or query.
Versions 15 and later
Android This function is now available for the Android applications.
New in version 15
Android This function is now available for the Android applications.
Android This function is now available for the Android applications.
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
Android Widget This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Android Widget This function is now available in Android Widget mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Android Widget This function is now available in Android Widget 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
// Select all the customers whose last name is Archambault
// and whose first name is Colin
SearchKey is string
SearchKey = HFilterIdentical(Customer, LastNameFirstName, "Archambault", "Colin")
HReadFirst(Customer, SearchKey)
WHILE NOT HOut()
Trace(Customer.CustomerName, Customer.City)
HReadNext(Customer, SearchKey)
END
// Disables the filter
HDeactivateFilter(Customer)
Syntax
<Result> = HFilterIdentical(<File Name>, <Name of Key Item>, <Value for 1st Key Component> [, <Value for 2nd Key Component> [,...]])
<Result>: Character string
Search item. Corresponds to:
  • the search key of data file if the filter is enabled.
  • an empty string ("") if the filter cannot be implemented.
<File Name>: Character string (with or without quotes)
Name of HFSQL data file, view or query used.
<Name of Key Item>: Character string (with or without quotes)
Name of key item onto which the filter will be applied. This item can be a simple key (string) or a composite key. Caution: this parameter must only contain letters, underlined characters or digits. Otherwise, the name must be enclosed in quotes.
<Value for 1st Key Component>: Type of each component of search key
Value sought for the first component of composite key.
The type of this parameter must correspond to the type of key item component on which the filter is defined.
<Value for 2nd Key Component>: Type of each component of search key
Value sought for the second component (the 3rd respectively) of composite key.
The type of this parameter must correspond to the type of key item component on which the filter is defined.
Remarks

Automatic management of composite keys

HFilterIdentical automatically manages the filters on the simple keys and on the composite keys.
Example: Using HFilterIdentical with a simple key:
Res = HFilterIdentical(Customer, LastName, "Archambault")
// Select the customer whose last name is Archambault
Example: Using HFilterIdentical with a composite key
Res = HFilterIdentical(Customer, LastNameFirstName, "Archambault", "Corentin")
// Select all the customers whose last name is Archambault and
// whose first name is Colin
This code line is equivalent to:
HFilter(Customer, LastNameFirstName, ...
HBuildKeyValue(Customer, FirstNameLastName, "Archambault", "Colin"), ...  
HBuildKeyValue(Customer, FirstNameLastName, "Archambault", "Colin")

Filter and filtered browse

After the call to HFilterIdentical, the data file must necessarily be browsed on the item returned by HFilterIdentical. The filter will be ignored if another item is used to browse the data file.
When a filter is defined and enabled on a data file (view or query), all records read correspond to the filter. If no other record corresponds to the filter during the browse:
  • HOut returns True.
  • the current record corresponds to the last record read with the filter.
For example:
On a filtered data file, after the function:the current record is:
HReadFirstthe first file record corresponding to the filter
HReadLastthe last file record corresponding to the filter
HReadNext (or HForward)the next record (or the next nth record) corresponding to the filter
HReadPrevious (or HBackward)the previous record (or the previous nth record) corresponding to the filter

Enabling/Disabling a filter

  • HDeactivateFilter is used to disable a filter.
  • HActivateFilter is used to re-enable a filter.
  • The filter is deleted when the data file (query or view) is closed (HClose or HOpenAnalysis for example).
  • A single filter can exist at a given time on a data file (query or view). If HFilterIdentical is used several times, only the last filter will be taken into account: the previous filters will be deleted. Similarly, if several filters are used (HFilter* functions), only the last filter will be taken into account.
WINDEVWEBDEV - Server codeReports and QueriesAndroidAndroid Widget Windows MobileAjaxUser code (UMC)Stored proceduresOLE DBNative Accesses

Data file not in HFSQL format

Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Windows Mobile wp230hf.dll
Java wd230java.jar
Linux wd230hf.so
Android wd230android.jar
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment