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.
HEndNoDatabaseAccess (Function)
Re-allows the access (which means the connection) to one or more databases accessible via a connection.
HNoDatabaseAccess (Function)
Denies all new connections to a database or to all databases.
HInfoLock (Function)
Returns information about the lock set on a table, on one or all the records in a table.
<Connection variable>.AddLink (Function)
Adds an integrity rule between two files on the server.
HActivateServerTrigger (Function)
Re-enables a server trigger that was disabled by HDeactivateServerTrigger.
<Connection variable>.RetrieveLog (Function)
Creates a text file containing the server logs between two given dates.
Client/Server transactions: Available isolation modes
The HFSQL engine proposes to isolate the transactions......
17. Project Management Hub
...Project Management Hub...
<Connection variable>.SendMessageToClient (Function)
Displays a message on the client computers.
<Connection variable>.DisconnectClient (Function)
Displays a message on the Client computer(s) and disconnects the application.
<Connection variable>.ListWatchedFiles (Function)
Returns a list of tables monitored by the HWatch function.
<Connection variable>.DeleteParameter (Function)
Deletes a parameter previously saved by HSaveParameter.
<Connection variable>.InfoView (Function)
Returns information about a materialized view.
<Connection variable>.LoadParameter (Function)
Reads a parameter that was saved from a stored procedure by HSaveParameter.
<Connection variable>.DeleteFile (Function)
Deletes HFSQL tables (.fic, .ndx, .ftx, .sdx and .mmo files, if any) from the server.
Custom-Folders in the analysis
Several file descriptions can be grouped into a "Custom-Folder"......
HAddLink (Function)
Adds an integrity rule between two tables on the server.
HRetrieveLog (Function)
Creates a text file containing the server logs between two given dates.