AYUDA EN LÍNEA
 WINDEVWEBDEV Y WINDEV MOBILE

Ayuda / WLanguage / Administrar bases de datos / HFSQL / Funciones HFSQL
  • Example 1: Initializing and browsing a query on HFSQL data files
  • Example 2: Initialization and browsing a query on an OLE DB file
HExecuteQuery (Example)
Example 1: Initializing and browsing a query on HFSQL data files
WINDEVWEBDEV - Código ServidorReportes y ConsultasJavaCódigo de Usuario (UMC)AjaxHFSQL ClassicHFSQL Client/ServerProcedimientos almacenadosHyper File 5.5 The following example is used to initialize a query and to browse it.
// Initializes the query
IF HExecuteQuery(QRY_MyQuery) = False THEN
Error("Error while initializing the query" + CR + HErrorInfo())
RETURN
END
 
// Read the first record of the query
HReadFirst(QRY_MyQuery)
WHILE NOT HOut()
 // Process on the query record
 ...
 // read the next record
 HReadNext()
END
HCancelDeclaration(QRY_MyQuery)
Example 2: Initialization and browsing a query on an OLE DB file
WINDEVWEBDEV - Código ServidorReportes y ConsultasCódigo de Usuario (UMC)AjaxOLE DB The following example is used to initialize a query and to browse it.
// MyQuery = "Select * from Customers where CustomerID =?"
// Customers is an OLEDB file that used the "MyConnection1" connection
 
// The query is run on "MyConnection1"
HExecuteQuery(MyQuery, hQueryDefault, 5)
 
// Change the connection used by the "Customers" file
HChangeConnection(Customers, "MyConnection2")
// The query is run on "MyConnection2"
HExecuteQuery(MyQuery, hQueryDefault, 5)
// Starts a transaction on "MyConnection3"
SQLTransaction(sqlStart, "MyConnection3")
// Runs the query on "MyConnection3"
// regardless of the connection used by the "Customers" file
HExecuteQuery(MyQuery, "MyConnection3", hQueryDefault, 5)
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