HReadSeekFirst (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: Performing an exact-match search
Example 2: Performing a search on a composite key

HReadSeekFirst (Example)

See the associated help page

Example 1: Performing an exact-match search

The "Customer" data file is browsed according to the "NAME" browse key, for the value contained in the sName variable.

HReadSeekFirst(Client, Nom, sNom)
IF HFound(Client) = True THEN
	ClientExistant()
ELSE
	ClientInconnu()
END

Example 2: Performing a search on a composite key

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(CLIENT, NOM_PRENOM, [sNom, sPrénom])
WHILE HFound(CLIENT) = True
	HDelete(CLIENT)
	HReadNext(CLIENT)
END