HRefreshSet (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Help

WLanguage

Management of databases

HFSQL functions

HFSQL Client/Server functions

HRefreshSet

Presentation

Example

Hot update of stored procedures on the HFSQL server

HAddScheduledOptimization

HCS.Timeout (Variable)

HDeleteScheduledBackup

HDeleteScheduledOptimization

HExecuteScheduledBackup

HExecuteScheduling

HInfoBackup

HInfoDatabaseProperty

HListScheduledOptimization

HModifyDatabaseProperty

HModifyDatabaseRights

HModifyFileProperty

HModifyFileRights

HModifyGroup

HModifyScheduledBackup

HModifyScheduledOptimization

HModifyScheduling

HModifyServerProperty

HNotifAddEmailRecipient

HNotifConfigure

HNotifDeleteCCRecipient

HNotifDeleteEmailRecipient

HNotifListCCRecipient

HNotifListEmailRecipient

Hot update of stored procedures on the HFSQL server

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HRefreshSet (Function)

In french: HMiseAJourCollection

Available only with this kind of connection

Creates or updates a set of procedures on a HFSQL server. The procedures and functions found in the set of procedures can be used as stored procedures.

Note: From version 19, HFSQL is the new name of HyperFileSQL.

Versions 22 and later

This function is now available for iPhone/iPad applications.

This function is now available in Universal Windows 10 App mode.

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for the Java applications.

New in version 22

This function is now available for iPhone/iPad applications.

This function is now available in Universal Windows 10 App mode.

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for the Java applications.

This function is now available for iPhone/iPad applications.

This function is now available in Universal Windows 10 App mode.

This function is now available in Android Widget mode.

This function is now available for Android applications.

This function is now available for the Java applications.

Example

// Refresh the set of procedures
// even if a more recent version is found on the server
HRefreshSet("MyConnection", MySet, True)

Syntax

<Result> = HRefreshSet(<Connection name> , <Name of 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 name>: Character string (with or without quotes)

Name of the connection to the server on which the set of procedures must be created or refreshed.

<Name of set of procedures>: Character string (with or without quotes)

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.
Versions 16 and later
The quotes are no longer mandatory for this parameter.
New in version 16
The quotes are no longer mandatory for this parameter.
The quotes are no longer mandatory for this parameter.

<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. HRefreshSet returns False if the global variables of the set of procedures have been modified. 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.

Note: If a procedure of the set is currently run, the update is locked until the end of execution of the procedure (HRefreshSet is a locking function). All stored procedures currently run are ended and all stored procedures called after the execution of HRefreshSet are locked until the set is updated on the server.

Component : wd240hf.dll