HForward (Example)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / Managing databases / HFSQL / HFSQL functions

Example 1: Advance to the 500th record in the "Product" data file according to the key Reference
Example 2: Advance to halfway through the "Customer" data file

HForward (Example)

See the associated help page

Example 1: Advance to the 500th record in the "Product" data file according to the key Reference

The following example selects the 500th record in the "Product" data file.

HFirst(Produit, Référence)
HForward(Produit, Référence, 499)

Example 2: Advance to halfway through the "Customer" data file

This example scrolls halfway through the "Customer" data file. The total number of records is calculated by HNbRec.

// positionnement à 50% du fichier de données "Client" sur la clé "Nom"
TotalEnr is int = HNbRec(Client)
HFirst(Client, Nom)
HForward(Client, Nom, TotalEnr/2)