ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

Notifications of an HFSQL server
A server may encounter problems without any user (or developer) noticing anything.
For example:
  • a scheduled task may fail,
  • an automatic backup may fail,
  • a node may become inactive in an HFSQL cluster, ...
Docker image of the HFSQL server
A Docker container with the HFSQL server is available on Docker Hub...
HOperationInProgress (Function)
Returns the list of automatic operations in progress on an HFSQL server.
HServerMaintenance (Function)
Checks and optimizes the system tables of an HFSQL server.
<Connection variable>.ServerMaintenance (Function)
Checks and optimizes the system tables of an HFSQL server.
Installing an HFSQL Client/Server server with an application
When creating the setup program of a WINDEV application using HFSQL Client/Server data files, the wizard allows you to...
HManageServerUpdate (Function)
Allows you to manage the automatic update of HFSQL Client/Server servers and to define how often to check for updates.
HStartServerUpdate (Function)
Used to immediately start the automatic server update.
<Connection variable>.StartServerUpdate (Function)
Used to immediately start the automatic server update.
<Connection variable>.OperationInProgress (Function)
Returns the list of automatic operations in progress on an HFSQL server.
InStoredProcedureMode (Function)
Indicates whether the code is run on an HFSQL server.
<Connection variable>.ManageServerUpdate (Function)
Used to manage the automatic update of HFSQL Client/Server servers by specifying the check frequency regarding the availability of updates.
HFSQL and Docker
Docker is a software platform that allows you to run applications in software containers on Linux (Docker runs like a daemon)...
HListServer (Function)
Lists the HFSQL servers installed on a computer.
<Connection variable>.AddUser (Function)
Adds a user to a database.
<Connection variable>.AddGroup (Function)
Adds a group of users.
HResetUser (Function)
Initializes the structure for user management (HUser) with the default values.
HResetGroup (Function)
Initializes the structure for group management (HGroup) with the default values.
HAddGroup (Function)
Adds a group of users.
HAddUser (Function)
Adds a user to a database.
HFSQL Control Center: HFSQL Cluster management
The HFSQL Control Center includes all the tools needed to manage HFSQL clusters......
<Connection variable>.ModifyGroup (Function)
Modifies the group information according to the elements found in the corresponding variables for group management.
<Connection variable>.InfoServerRights (Function)
Allows you to find out the rights granted to a user or group of users on a server.
HModifyGroup (Function)
Modifies the group information according to the elements found in the corresponding variables for group management.
<Connection variable>.InfoDatabaseRights (Function)
Allows you to find out the rights granted to a user or to a group on a database.
<Connection variable>.AddScheduledBackup (Function)
Adds a scheduling for full backup (with or without differential backup) on the server defined by the connection.
HInfoServerRights (Function)
Allows you to find out the rights granted to a user or group of users on a server.
<Connection variable>.InfoUser (Function)
Updates the variables for user management with the information regarding the specified user.
HClearWorkingDir (Function)
Clears and destroys the temporary directory previously created when HServerWorkingDir was executed.
<Connection variable>.ExecuteProcedure (Function)
Runs a stored procedure.
HFSQL Control Center: Open an analysis
The HFSQL Control Center allows you to fully manage an analysis......
Replication management functions
Three types of replication are proposed......
HAddScheduledBackup (Function)
Adds a scheduling for full backup (with or without differential backup) on the server defined by the connection.
HInfoDatabaseRights (Function)
Allows you to find out the rights granted to a user or to a group on a database.
OLE DB provider for HFSQL
The OLE DB provider on HFSQL is used to access an HFSQL database (Classic or Client/Server) from an external software that manages the accesses by OLE DB......
HInfoUser (Function)
Updates the variables for user management with the information regarding the specified user.
13. Universal replication
HExecuteProcedure (Function)
Runs a stored procedure.
<Connection variable>.ExecuteScheduledBackup (Function)
Forces the execution of a scheduled backup.