ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / How to proceed? / Managing the database
  • Overview
  • Method 1: Path functions
  • Code example
  • Method 2: Instruction FOR EVERYTHING
  • Code example
  • Method 3: HFilter function
  • Example
  • Method 4: Using SQL queries
  • Example
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Overview
There are multiple methods to loop though a data file using filters:
Method 1: Path functions
This method uses the following WLanguage functions to loop through data files:
HReadSeek is used to access the first record corresponding to the value of the minimum bound for the search key.
HReadNext reads the next record that matches the search.
HFound checks whether there is a record that matches the search value.

Code example

// Parcours des enregistrements du fichier de données Client dont la ville est MONTPELLIER. 
HReadSeek(CLIENT, Ville, "MONTPELLIER")
WHILE HFound(CLIENT)
	// Traitement de l'enregistrement CLIENT
	// ...
	HReadNext(CLIENT, Ville)
END
Method 2: Instruction FOR EVERYTHING
The FOR EACH statement loops through the records of a data file. In our case, this statement will be used to read the records found in a data file according to a filter.
The FOR EACH statement expects the following parameters:
  • the name of the data file to loop through.
  • the name of the index (or key) used to sort the records.
  • the filtering value.
The first record and the next record are read by the FOR EACH statement. There is no need to use the HReadXXX functions.

Code example

// Parcours des enregistrements du fichier de données Client dont la ville est MONTPELLIER. 
FOR EACH CLIENT where VILLE = "MONTPELLIER"
	// Traitement de l'enregistrement CLIENT
END
Method 3: HFilter function
  1. Use HFilter to apply a filter on the records of the data file.
  2. Loop through the filtered data file using the standard read functions.
  3. At the end of the operation, disable the filter with HDeactivateFilter.

Example

Find orders whose date is between 02/01/2017 and 02/28/2017.
// On applique le filtre
HFilter(COMMANDE, DATECOMMANDE, "20170201", "20170228")
// On parcourt le fichier de données
FOR EACH COMMANDE
	// On traite la commande lue
END
// On désactive le filtre
HDeactivateFilter(COMMANDE)
Note: The HFilter function is more flexible than the previous methods. It can also be used to manage more filter capabilities. For more details, see the online help about HFilter.
Method 4: Using SQL queries
To loop through the data file using a filter via a query:
  1. Create the query. The query is used to filter the requested records.
    Reminder: A SQL query can be performed:
    • in the query editor.
    • programmatically.
    For more details on how to create a query, see Creating a query.
  2. Execute the query (HExecuteQuery or HExecuteSQLQuery).
  3. Read the query result by looping through the data file.
  4. Free the query (HFreeQuery).

Example

HExecuteQuery(REQ_ListeClient)
FOR EACH REQ_ListeClient
	// Traitement du client lu dans la requête
END
HFreeQuery(REQ_ListeClient)
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 04/03/2025

Send a report | Local help