HManageServerUpdate (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions

Default PC SOFT update server
Custom update server

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HManageServerUpdate (Function)

In french: HGèreMiseAJourServeur

Allows you to manage the automatic update of HFSQL Client/Server servers and to define how often to check for updates. If an update is available, the HFSQL server is automatically updated.

Remark: Two rights are required to use this function:

The rights to manage the server.
The rights to stop the server.

These rights correspond respectively to the hRightsManageServer and hRightsStopServer constants used in HInfoServerRights and HModifyServerRights.

Example

MyConnection is Connection
MyScheduling is hScheduling

// Enables the server update according to a specific scheduling
HManageServerUpdate(MyConnection, MyScheduling)

Syntax

(<Former Scheduling>, <Former URL>) = HManageServerUpdate(<Connection> [, <Scheduling> [, <URL>]])

<Former Scheduling>: hScheduling variable

hScheduling variable containing the characteristics of the previous scheduling.

<Former URL>: Character string

Former URL for downloading the server update.

<Connection>: Character string or Connection variable

Connection to a database. This connection corresponds to:
the name of the connection defined in the data model editor or with HDescribeConnection or HOpenConnection.
the name of a variable of type Connection.

<Scheduling>: Optional hScheduling variable

Name of the hScheduling variable corresponding to the options for scheduling the server update.

<URL>: Optional character string

URL to the custom update server. For more details, see Custom update server.
Empty string (default) to use the official update server of PC SOFT.

Remarks

Default PC SOFT update server

Fore each update, PC SOFT provides automatic update packages for the HFSQL server in production (for the version currently used).

These packages have been thoroughly checked by our services.

Custom update server

You can use a custom update server for the HFSQL server. This allows you to control the HFSQL server updates of the users. You can for example validate the use of a new version before releasing it.

To create a custom update server for HFSQL servers, you must:

Install a Web server (IIS or Apache) on the selected computer.
Create the following MIME types on the Web server if they do not exist:
- .json -> application/json
- .sign -> application/byte-stream
- .zip -> application/x-compress
Create a directory at the root of the Web server. This directory will contain the update packages. Example: C:\inetpub\wwwroot\hfsql_packs
This directory must contain:
- A json file containing the names of the packages to be used according to the versions (see below). The name of this file must be "hfsql_updateinfo.json".
- The update packages (".zip" files).
- The signature files corresponding to the packages (".sign" extension).
These packages and their signatures are available at: http://package.windev.com/hfsql/.

For example:

Web server for updates: srvupd
UNC directory containing the updates: \\srvupd\hfsql_packs\
URL for updates: http://srvupd/hfsql_packs/

Example of Json file:

{
"pack": [
{
"major_version": 22,
"language" : "F",
"version" : "220099",
"min_version" : "220036",

"pack": [
{
"platform": "win32",
"data" : "srv_hfsql_win32_90F220099z"
},
{
"platform": "win64",
"data" : "srv_hfsql_win64_90F220099z"
},
{
"platform": "linux32",
"data" : "srv_hfsql_linux32_90F220099z"
},
{
"platform": "linux64",
"data" : "srv_hfsql_linux64_90F220099z"
}
]
}
]
}

where:

major_version: corresponds to the major version of the package (22, 23, etc.). Only the HFSQL servers corresponding to this version will be updated.
language: corresponds to the server language (E for English, F for French, etc.).
version: corresponds to the HFSQL server version in the package.
min_version: corresponds to the minimum version from which the package can be applied.
pack: used to specify the characteristics of the packages.
platform: platform corresponding to the package:
- win32: 32-bit Windows
- win64: 64-bit Windows
- linux32: 32-bit Linux
- linux64: 64-bit Linux
data: corresponds to the name of the package (without extension).

Remark: A single package may be referenced according to the platform used by the HFSQL servers.

Component: wd300hf.dll