AYUDA EN LÍNEA
 WINDEV, WEBDEV Y WINDEV MOBILE
Ayuda / WLanguage / Administrar bases de datos / HFSQL / Funciones HFSQL
  • Example 1: Simple generic search
  • Example 2: Performing a search on a composite key
  • Example 3: Seeking a customer with condition
HReadSeek (Example)
Example 1: Simple generic search
WINDEVWEBDEV - Código ServidorReportes y ConsultasJavaCódigo de Usuario (UMC)PHPAjaxHFSQL ClassicHFSQL Client/ServerHyper File 5.5OLE DBConectores Nativos
The following example is used to perform a generic search on the customer name. If the customer is found, the CustomerFound procedure is run ; if no customer is found, the UnknownCustomer procedure is run.
// Simple generic search
HReadSeek(CUSTOMER, CUSTNAME, sCustName)
IF HFound(CUSTOMER) = True THEN
CustomerFound()
ELSE
UnknownCustomer()
END
Example 2: Performing a search on a composite key
WINDEVWEBDEV - Código ServidorReportes y ConsultasJavaCódigo de Usuario (UMC)PHPAjaxHFSQL ClassicHFSQL Client/ServerHyper File 5.5OLE DBConectores Nativos
The following example is used to perform a search on a composite key (last name and first name). The customers found are deleted.
// Find the record
HReadSeek(CUSTOMER, LASTNAME_FIRSTNAME, [sLastName, sFirstName])
 
WHILE HFound(CUSTOMER) = True
// Deletion
HDelete(CUSTOMER)
HReadNext(CUSTOMER,LASTNAME_FIRSTNAME)
END
Example 3: Seeking a customer with condition
WINDEVWEBDEV - Código ServidorReportes y ConsultasJavaCódigo de Usuario (UMC)PHPAjaxHFSQL ClassicHFSQL Client/ServerHyper File 5.5OLE DBConectores Nativos
This example is used to find a customer whose turnover is greater than a specified value.
HReadSeek(CUSTOMER, Turnover, X)
WHILE HOut(CUSTOMER) = False
Add_Customer_List()
HReadNext(CUSTOMER)
END
Versión mínima requerida
  • Versión 9
Esta página también está disponible para…
Comentarios
Haga clic en [Agregar] para publicar un comentario

Última modificación: 27/05/2022

Señalar un error o enviar una sugerencia | Ayuda local