ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

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)
Example 1: Performing an exact-match search
WINDEVJavaHFSQL ClassicHFSQL Client/ServerStored proceduresHyper File 5.5OLE DBNative Connectors (Native Accesses)
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
WINDEVJavaHFSQL ClassicHFSQL Client/ServerStored proceduresHyper File 5.5OLE DBNative 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(CLIENT, NOM_PRENOM, [sNom, sPrénom])
WHILE HFound(CLIENT) = True
	HDelete(CLIENT)
	HReadNext(CLIENT)
END
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/27/2025

Send a report | Local help