PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN

This content has been translated automatically. Click here to view the French version.
  • Hot update of stored procedures on the HFSQL server
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Warning
From version 27, HRefreshSet is kept for backward compatibility. This function is replaced by HRefreshSet.
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.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 22 and later
iPhone/iPad This function is now available for iPhone/iPad applications.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Android Widget This function is now available in Android widget mode.
Android This function is now available for Android applications.
WINDEVJava This function is now available for Java applications.
New in version 22
iPhone/iPad This function is now available for iPhone/iPad applications.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Android Widget This function is now available in Android widget mode.
Android This function is now available for Android applications.
WINDEVJava This function is now available for Java applications.
iPhone/iPad This function is now available for iPhone/iPad applications.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Android Widget This function is now available in Android widget mode.
Android This function is now available for Android applications.
WINDEVJava This function is now available for Java applications.
Example
// Mettre à jour la collection de procédures
// même si le serveur possède une version plus récente
HUpdateSet("MaConnexion", MaCollection, True)
Syntax
<Result> = HRefreshSet(<Connection> , <Set of procedures> [, <Force>])
<Result>: Boolean
  • True if the set of procedures was created or refreshed,
  • 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 refreshed. This connection corresponds to:
<Set of procedures>: Character string
Name of the set of procedures to create or refresh on the server. If this parameter corresponds to "*", all the sets of procedures will be refreshed or created on the server.
<Force>: Optional boolean
  • False (default value): the set of procedures will be created or refreshed:
    • 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 set of procedures will be refreshed in any case.
Remarks

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 HRefreshSet. 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 procedure collection have been modified, function HRefreshSet returns False. In this case, all the users must be disconnected before the update can be performed.
    Caution: In this last case, if the update was performed, the users connected before the update will use during the next execution of a stored procedure:
    • the new code of stored procedure,
    • the global variables with the values defined before the update.
Remark: If an Procedure from the collection of Procedure s is running, the update is blocked until the Procedure is finished (the HRefreshSet function is blocking). All running stored procedures are terminated and all stored procedures called after the HRefreshSet function is executed are blocked until the collection is updated on the server.
Business / UI classification: Business Logic
Component: wd270hf.dll
Minimum version required
  • Version 11
This page is also available for…
Comments
Click [Add] to post a comment