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...
<Connection variable>.ServerMaintenance (Function)
Checks and optimizes the system tables of an HFSQL server.
HFSQL and Docker
Docker is a software platform that allows you to run applications in software containers on Linux (Docker runs like a daemon)...
<Connection variable>.StartServerUpdate (Function)
Used to immediately start the automatic server update.
HServerMaintenance (Function)
Checks and optimizes the system tables of an HFSQL server.
HManageServerUpdate (Function)
Allows you to manage the automatic update of HFSQL Client/Server servers and to define how often to check for updates.
<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.
<Connection variable>.OperationInProgress (Function)
Returns the list of automatic operations in progress on an HFSQL server.
HOperationInProgress (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.
Installing an HFSQL Client/Server server with an application
When creating the setup program of a WINDEV application using HFSQL Client/Server tables, the wizard allows you to...
HListServer (Function)
Lists the HFSQL servers installed on a computer.
HStartServerUpdate (Function)
Used to immediately start the automatic server update.
<Connection variable>.ListDatabase (Function)
Lists the Client/Server databases associated with a connection....
HModifyScheduledBackup (Function)
Modifies a backup scheduling.
HDeleteBackup (Function)
Deletes a backup previously created with HBackup.
HDeleteServerTrigger (Function)
Deletes a server trigger.
HDescribeServerTrigger (Function)
Adds or modifies a server trigger.
<Connection variable>.InfoServer (Function)
Returns the specified information about the server.
HInfoLog (Function)
Returns information about the server logs.
Native SQL Server Connector: Programming with HFSQL functions
To use an SQL Server database with Native Connector, the structure of SQL Server tables must be imported into the data model analysis......
Using ODBC on HFSQL Classic via JDBC
The ODBC driver on HFSQL Classic is used to access a HFSQL Classic database from an external database software that supports ODBC accesses......
<Connection variable>.DeleteLink (Function)
Deletes an integrity rule between two data files on the server.
Application triggers
A trigger is a WLanguage procedure automatically called by the HFSQL engine whenever a modification is performed (addition, deletion, modification, ...) on a record of a table....
<Connection variable>.ModifyViewRights (Function)
Sets the rights granted to a user or group on an SQL view or on a materialized view.
<Connection variable>.InfoViewRights (Function)
Gets the rights granted to a user or group on an SQL view or on a materialized view.
ODBC on HFSQL via Visual .NET (in C#)
The ODBC driver on HFSQL Classic (single-user and multi-user) is used to access a HFSQL Classic database from an external database software that supports ODBC accesses......
HSuggestKeyStart (Function)
Starts collecting information on executed queries.
<Connection variable>.EndNoDatabaseAccess (Function)
Re-allows the access (which means the connection) to one or more databases accessible via a connection.
<Variable Connexion>ExecuteAsynchronousProcedure (Function)
Executes a stored procedure in asynchronous mode. This new function is available from WINDEV Suite SaaS 2025 Update 2....
HInfoServer (Function)
Returns the specified information about the server.
HListDatabase (Function)
Lists the Client/Server databases associated with a connection....
HDeleteLink (Function)
Deletes an integrity rule between two tables on the server.
4. HFSQL Classic