ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

Docker image of the HFSQL server
A Docker container with the HFSQL server is available on Docker Hub...
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, ...
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.
HOperationInProgress (Function)
Returns the list of automatic operations in progress on an HFSQL server.
<Connection variable>.ServerMaintenance (Function)
Checks and optimizes the system tables of an HFSQL server.
<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.
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.
<Source>.Alias (Function)
Creates a logical alias of a data file (or query) or cancels all existing aliases.
<Source>.UnlockFile (Function)
Unlocks the records of a data file: locked by HLockFile. individually locked by a locking read function....
<Source>.UnlockRecNum (Function)
Unlocks a record locked by: HLockRecNum, a read function used with a locking parameter (HRead associated with the hLockWrite or hLockReadWrite constant for example)....
Link functions (prefix syntax)
Link functions are used to link the interface with the data files (and vice versa)....
<Source>.DescribeFile (Function)
Describes a data file programmatically.
<Source>.Close (Function)
Closes a data file or all the data files opened by the current user: all the corresponding physical data files are closed for the current user.
<Source>.SetDuplicates (Function)
Enables or disables the management of duplicates on a unique key.
<Source>.Open (Function)
Opens a data file.
HSetREP (Function)
Enables or disables the management of .REP file.
HActivateTrigger (Function)
Re-enables a trigger that was disabled by HDeactivateTrigger.
HDeactivateTrigger (Function)
Disables a trigger.
HClose (Function)
Closes either a table or all tables opened by the current user: all corresponding physical tables are closed for the current user.
HErrorIntegrity (Function)
Used to check whether an integrity error occurred.
HExecuteQueryAsynchronous (Function)
Executes a SELECT query asynchronously.
<Polygon2D variable>.IsValid (Function)
Checks whether the specified 2D polygon is valid according to the OGC rules.
Link functions
Link functions are used to link the interface with the tables and vice versa. These functions are as follows:...
<Source>.ReadSeek (Function)
Sets the position on the first record whose value for a specific item is greater than or equal to a sought value (generic search).
HUnlockRecNum (Function)
Unlocks a record locked by: HLockRecNum, a read function used with a locking parameter (HRead associated with the hLockWrite or hLockReadWrite constant for example)....
HSetDuplicates (Function)
Enables or disables the management of duplicates on a unique key.
<Source>.FileExist (Function)
Determines: whether a file exists, which means whether it was physically created (HCreation or HCreationIfNotFound). whether a view or a query was defined....
<Source>.ListStopWord (Function)
Returns the list of stop words used by a full-text index.
<Source>.ListSynonym (Function)
Returns the list of synonyms used by a full-text index.