AYUDA EN LÍNEA
 WINDEVWEBDEV Y WINDEV MOBILE

Este contenido se ha traducido automáticamente.  Haga clic aquí  para ver la versión en inglés.
Ayuda / WLanguage / Administrar bases de datos / HFSQL / Funciones HFSQL Client/Server
  • Hot update of stored procedures on the HFSQL server
WINDEV
WindowsLinuxJavaReportes y ConsultasCódigo de Usuario (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Código Navegador
WINDEV Mobile
AndroidWidget Android iPhone/iPadIOS WidgetApple WatchMac Catalyst
Otros
Procedimientos almacenados
Advertencia
A partir de la versión 27, HRefreshSet se conserva por motivos de compatibilidad. Esta función ha sido reemplazada por HUpdateSet.
Creates or updates a set of procedures on an HFSQL server. The procedures and functions found in the set of procedures can be used as stored procedures.
Ejemplo
// Update the set of procedures 
// even if a more recent version is found on the server
HUpdateSet("MyConnection", MySet, True)
Sintaxis
<Result> = HUpdateSet(<Connection> , <Set of procedures> [, <Force>])
<Result>: Boolean
  • True if the set of procedures was created or updated,
  • False otherwise. HError is used to identify the error.
<Connection>: Character string or Connection variable
Connection to the server on which the set of procedures must be created or updated. This connection corresponds to:
<Set of procedures>: Character string
Name of the set of procedures to be created or updated on the server. If this parameter corresponds to "*", all the sets of procedures will be updated or created on the server.
<Force>: Optional boolean
  • False (default): the procedure collection will be created or updated:
    • if the set of procedures is not found on the server.
    • if an earlier version of the set of procedures is found on the server.
  • True: the collection of procedures will be updated in all cases.
Observaciones

Hot update of stored procedures on the HFSQL server

The hot update of stored procedures on the HFSQL server consists in updating the sets of stored procedures on the server while the application is currently used. This operation is used to perform an update without disconnecting all users.
This update can be performed by HUpdateSet. The following conditions are required to perform this update:
  • If no procedure of the set was run, the set of procedures can be updated on the server.
  • If a procedure of the set was run, the set of procedures can be updated only if the modification of the set of procedures does not affect the global variables. If the global variables of the set of procedures have been modified, HUpdateSet returns False. In this case, all the users must be disconnected to perform the update.
    Warning In the latter case, if the update has been carried out, users logged in before the update will use a stored procedure the next time they run it:
    • the new code of stored procedure,
    • the global variables with the values defined before the update.
Note If a procedure from the Procedure collection is currently running, the update is blocked until the procedure has finished (the function HUpdateSet function is blocking). All the stored procedures being executed are ended, and all the stored procedures called after the execution of HUpdateSet are locked until the set is updated on the server.
Clasificación Lógica de negocio / UI: Lógica de negocio
Componente: wd300hf.dll
Versión mínima requerida
  • Versión 11
Esta página también está disponible para…
Comentarios
Haga clic en [Agregar] para publicar un comentario

Última modificación: 12/06/2025

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