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>.ListScheduledOptimization (Function)
Lists the scheduled optimization tasks of HFSQL Client/Server tables for a connection....
<Connection variable>.DeleteScheduledOptimization (Function)
Deletes a scheduled optimization task from HFSQL Client/Server data files....
HInfoFileRights (Function)
Gets the rights granted to a user or group on an HFSQL Client/Server table....
<Connection variable>.ModifyDatabaseRights (Function)
Sets the rights granted to a user or group for an HFSQL Client/Server database....
HModifyDatabaseRights (Function)
Sets the rights granted to a user or group for an HFSQL Client/Server database....
HModifyFileRights (Function)
Sets the rights granted to a user or group on an HFSQL Client/Server table....
Structure of log files (HFSQL Client/Server)
The following files are automatically created when logging an HFSQL Client/Server table......
hBackupDescription (Variable type)
The hBackupDescription type is used to programmatically describe an HFSQL Client/Server backup....
<Connection variable>.ModifyFileRights (Function)
Sets the rights granted to a user or group on an HFSQL Client/Server table....
HListScheduledOptimization (Function)
Lists the scheduled optimization tasks of HFSQL Client/Server tables for a connection....
<Connection variable>.InfoFileRights (Function)
Gets the rights granted to a user or group on an HFSQL Client/Server table....
Transactions in HFSQL Client/Server mode
To keep maximum compatibility between HFSQL Classic applications (single-user or multi-user) and HFSQL Client/Server applications, the transaction mechanism in HFSQL Client/Server mode is similar to the one in HFSQL Classic mode......
5. HFSQL Client/Server
A WINDEV Mobile application can also use an HFSQL database in Client/Server mode....
HFSQL Client/Server: Scheduled optimization
Scheduled optimization is a mechanism for automatically optimizing your database......
5. HFSQL Cient/Server
Authentication via Active Directory
Kerberos is an authentication mode based on the use of tickets and secret keys......
HSimulateNetwork (Function)
Simulates the operating mode of HFSQL Client/Server on an ADSL or 3G network....
hScheduledTask (Type of variable)
The hScheduledTask type is used to manage a scheduled HFSQL Client/Server task through programming......