PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Default PC SOFT update server
  • Custom update server
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Allows you to manage the automatic update of HFSQL Client/Server servers by specifying the check frequency regarding the availability of updates. If an update is available, the HFSQL server is automatically updated.
Note: Two rights are required to use this function:
  • The rights to manage the server.
  • The rights to stop the server.
These rights respectively correspond to the hRightsManageServer and hRightsStopServer constants used in HInfoServerRights and HModifyServerRights.
Example
// Enables the server update according to a specific scheduling
HManageServerUpdate(MyConnection, MyScheduling)
Syntax
(<Former Scheduling>, <Former URL>) = HManageServerUpdate(<Connection Name> [, <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 Name>: Character string or Connection variable
Name of the connection to a database. This connection was defined:
  • in the data model editor.
  • by HDescribeConnection. The description of the connection must be known when running the function.
  • by a Connection variable.
<Scheduling>: Optional hScheduling variable
Name of the hScheduling variable corresponding to the options for scheduling the server update.
<URL>: Optional character string (with quotes)
  • URL to the custom update server. See Custom update server for more details.
  • Empty string (default value) to use the official update server of PC SOFT.
Remarks

Default PC SOFT update server

Fore each update, PC SOFT proposes packs allowing you to automatically update the HFSQL server in production (for the version currently used).
These packs have been thoroughly checked by our services.

Custom update server

You have the ability to use a custom update server for the HFSQL server. This allows you to control the update of HFSQL servers of the users. You can for example validate the use of a new version before releasing it.
To create a custom update server for the HFSQL servers, you must:
  1. Install a Web server (IIS or Apache) on the selected computer.
  2. 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
  3. Create a directory at the root of the Web server. This directory will contain the update packs. Example: C:\inetpub\wwwroot\hfsql_packs
    This directory must contain:
    • A json file containing the names of the packs to use according to the versions (see below).
    • The packs corresponding to the updates (packs in zip format with ".zip" extension).
    • The signature files corresponding to the packs (".sign" extension).
    These packs and their signatures are available from the following address: 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 pack (22, 23, ...). Only the HFSQL servers corresponding to this version will be updated.
  • language: corresponds to the server language (F for French, A for English, ...).
  • version: corresponds to the version of the HFSQL server found in the pack.
  • min_version: corresponds to the minimum version from which the pack can be applied.
  • pack: used to give the characteristics of the packs.
  • platform: platform corresponding to the pack:
    • win32: 32-bit Windows
    • win64: 64-bit Windows
    • linux32: 32-bit Linux
    • linux64: 64-bit Linux
  • data: corresponds to the name of the pack (without extension).
Note: A single pack may be referenced according to the platform used by the HFSQL servers.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Linux wd230hf.so
See also
Minimum required version
  • Version 22
This page is also available for…
Comments
Click [Add] to post a comment