PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
  • Example 1: Performing an exact-match search for users
  • Example 2: Performing a search on a composite key
  • Example 3: Searching for customers according to their gross sales
HReadSeekFirst (Example)
Example 1: Performing an exact-match search for users
Windows MobileJavaUser code (UMC)PHPAjaxHFSQLHFSQL Client/ServerStored proceduresNative Connectors (Native Accesses) The "Customer" file is browsed according to the "NAME" key, for the value contained in the sName variable.
HReadSeekFirst(Customer, Name, sName)
IF HFound(Customer) = True THEN
CustomerFound()
ELSE
UnknownCustomer()
END
Example 2: Performing a search on a composite key
Windows MobileJavaUser code (UMC)PHPAjaxHFSQLHFSQL Client/ServerStored proceduresNative Connectors (Native Accesses) This example is used to find and delete all the customers who have a specific last name and a specific first name. The search is performed on a composite key. The record is read.
HReadSeekFirst(CUSTOMER, LASTNAME_FIRSTNAME, [sLastName, sFirstName])
WHILE HFound(CUSTOMER) = True
HDelete(CUSTOMER)
HReadNext(CUSTOMER)
END
Example 3: Searching for customers according to their gross sales
Windows Mobile This example allows you to search for all the customers whose gross sales are greater than a specified value.
HReadSeekFirst(CUSTOMER, Turnover, X)
WHILE HOut(CUSTOMER) = False
AddCustomerList()
HReadNext(CUSTOMER)
END
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment