ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL functions
  • Example 1: Moving to the 500th record in the Product file according to the Reference key
  • Example 2: Moving forward to the mid-point of CUSTOMER file
HForward (Example)
Example 1: Moving to the 500th record in the Product file according to the Reference key
WINDEVWEBDEV - Server codeReports and QueriesJavaUser code (UMC)AjaxHFSQL ClassicHFSQL Client/ServerHyper File 5.5OLE DBNative Connectors (Native Accesses) The following example selects the 500th record found in the "Product" file.
HFirst(Product, Reference)
HForward(Product, Reference, 499)
Example 2: Moving forward to the mid-point of CUSTOMER file
WINDEVWEBDEV - Server codeReports and QueriesJavaUser code (UMC)AjaxHFSQL ClassicHFSQL Client/ServerHyper File 5.5OLE DBNative Connectors (Native Accesses) This example moves forward to the mid-point of the Customer" file. The total number of records is calculated by HNbRec.
// point to the half-waypoint of the "Customer" file using the "Name" key
TotalRec is int = HNbRec(Customer)
HFirst(Customer, Name)
HForward(Customer, Name, TotalRec/2)
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help