ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / How to proceed? / Managing the database
  • Overview
  • Method 1: Read functions
  • Code example
  • Method 2: FOR EACH statement
  • Code example
  • Method 3: HFilter function
  • Example
  • Method 4: Using an SQL query
  • Example
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Overview
There are multiple methods to loop though a data file using filters:
Method 1: Read 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

// Loop through the records of the Customer file whose city is PARIS.
 
HReadSeek(CUSTOMER, City, "PARIS")
WHILE HFound(CUSTOMER)
// Process the CUSTOMER record
 
HReadNext(CUSTOMER, City)
END
Method 2: FOR EACH statement
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

// Loop through the records of the Customer file whose city is PARIS.
FOR EACH CUSTOMER where CITY = "PARIS"
// Process the CUSTOMER record
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.
// Apply the filter
HFilter(ORDER, ORDERDATE, "20170201", "20170228")
 
// Loop through the file
FOR EACH ORDER
// Process the order read
END
 
 
// Disable filter
HDeactivateFilter(ORDER)
Note: HFilter is easier to use 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 an SQL query
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: An 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(QRY_CustomerList)
FOR EACH QRY_CustomerList
// Process the customer read in the query
END
HFreeQuery(QRY_CustomerList)
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 01/06/2023

Send a report | Local help