AYUDA EN LÍNEA
 WINDEVWEBDEV Y WINDEV MOBILE

Ayuda / WLanguage / Administrar bases de datos / HFSQL / Funciones HFSQL
  • Example: Initializing and browsing an SQL query
  • Example: Connecting to an SQL Server database and executing a query
HExecuteSQLQuery (Example)
Example: Initializing and browsing an SQL query
WINDEVWEBDEV - Código ServidorReportes y ConsultasCódigo de Usuario (UMC)PHPAjaxHFSQL ClassicHFSQL Client/ServerHyper File 5.5OLE DBConectores Nativos The following example is used to initialize a query and to browse it. This example uses the Data Source type to handle the query.
MyQuery is Data Source
// Initializes the query
IF NOT HExecuteSQLQuery(MyQuery, ...
"SELECT LASTNAME,FIRSTNAME FROM CUSTOMER WHERE CUSTOMER.LASTNAME = 'SMITH'") THEN
Error("Error while initializing the query" + CR + HErrorInfo())
RETURN
END
 
// Read the first record of the query
HReadFirst(MyQuery)
WHILE NOT HOut()
  // Process on the query record
  // Access to the items via MyQuery.<Item name>
  ...
  // Read the next record
  HReadNext()
END
Example: Connecting to an SQL Server database and executing a query
WINDEVWEBDEV - Código ServidorReportes y ConsultasCódigo de Usuario (UMC)PHPAjax
CustomerQry is Data Source
IF NOT HDescribeConnection("MyConnection", "sa", "","NATIVESQL", "", ...
hNativeAccessSQLServer, hOReadWrite) THEN
    Error(HErrorInfo())
ELSE
    // Open the connection
    HOpenConnection("MyConnection")
    HourGlass()
    // Execute query
    IF HExecuteSQLQuery(CustomerQry, "MyConnection", hQueryDefault, ...
"SELECT * FROM Store") THEN
      // Browse the result
      HReadFirst(CustomerQry)
      IF NOT HOut(CustomerQry) THEN
        FileToMemoryTable(TABLE_MyTable, ...
CustomerQry)
      END
    END
    HourGlass(False)
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