PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • 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
Reports and QueriesHFSQLHFSQL 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
Reports and QueriesHFSQLHFSQL 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 hald-way point 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