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.
HPass (Function)
Defines the password used to create or open a data file.
HFSQL management functions
List of functions for HFSQL management...
HTransactionInterrupted (Function)
Used to find out whether a transaction was interrupted (the transaction was neither validated nor canceled).
<Source>.RecordDate (Function)
Returns the date and time that an HFSQL record was last modified (Classic or Client/Server)....
<Connection variable>.TransactionStart (Function)
Starts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file.
HListReindexingHistory (Function)
Lists the operations performed on current data files, over the last 24 hours, or on the last 1000 files. These operations include reindexing, recalculation of statistics, memo verification, index verification, etc. This new function is available from WINDEV Suite SaaS 2025 - Update 2....
<Source>.ChangeDir (Function)
Changes the path to a data file (i.e. directory in which the file will be handled).
Transactions in SQL
Starting with version 21, you can manage transactions in SQL code......
<Source>.TransactionFree (Function)
Transforms all "in transaction" records into "Normal" records if they do not belong to an ongoing transaction.
<Source>.ChangeConnection (Function)
Dynamically changes the connection associated with a data file.
<Source>.SetTransaction (Function)
Enables or disables the management of transactions for one or more files.
HSetTransaction (Function)
Enables or disables the management of transactions for one or more files.
HChangeConnection (Function)
Dynamically changes the connection associated with a data file.
HChangeDir (Function)
Changes the path to a data file (i.e. directory in which the file will be handled).
HTransactionFree (Function)
Transforms all the records "in transaction" into "Normal" records if these records do not belong to a transaction currently in progress.
WINDEV concepts
<Connection variable>.Transaction (Function)
Starts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file.
HTransactionStart (Function)
Starts a transaction on the data files (HFSQL or accessed via a Native Connector) and creates the transaction file.
HTransaction (Function)
Starts a transaction on the data files (HFSQL or accessed via a Native Connector) and creates the transaction file.
Errors while managing data files
When an HFSQL function fails (returns False for example), the corresponding error number is returned by HError......
<Connection variable>.TransactionCancel (Function)
If a transaction is in progress, cancels all the operations performed on the data files in transaction since the start of transaction.
<Connection variable>.TransactionEnd (Function)
Validates the current transaction: the modifications performed on the data file since the start of transaction (HTransactionStart) are validated. the transaction file is deleted (if the transaction is the last transaction in progress for a network application) the records locked in read-only by the transaction are unlocked....
WDMap: Overview
WDMap is a tool used to view and handle a data file while developing an application......
HTransactionEnd (Function)
Validates the current transaction: the modifications performed on the data file since the start of transaction (HTransactionStart) are validated. the transaction file is deleted (if the transaction is the last transaction in progress for a network application) the records locked in read-only by the transaction are unlocked....
HTransactionCancel (Function)
If a transaction is in progress, cancels all the operations performed on the data files in transaction since the start of transaction.