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.
HExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
HReadSeek (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).
HIndex (Function)
Rebuilds the file index (".NDX" file).
HCreation (Function)
Creates an empty data file (".FIC" extension) with the index file and the memo file if necessary.
Server triggers
Server triggers are stored procedures executed by the server before or after a write operation performed on a database file......
HGetCurrentPosition (Function)
Returns the approximate position of current record in the data file.
WDModFic : Tool for automatic modification of data files
WDModFic is a tool used to perform the automatic modification of the data files found on the development computer and on the end-user computers......
Compression (Property)
The Compression property gets and sets the data compression mode.
HState (Example)
Usage example of the HState function
HRecNum (Example)
Usage example of the HRecNum function
HListKey (Example)
Usage example of the HListKey function
HErrorInfo (Example)
Usage example of the HErrorInfo function
HNbRec (Example)
Usage example of the HNbRec function
HChangeName (Example)
Usage example of the HChangeName function
HMergeView (Example)
Usage example of the HMergeView function
HDuplicateRecord (Function)
Duplicates the record read in a table: the record found in memory is added into the table (query or view).
HListItem (Example)
Usage example of the HListItem function
Installing a WEBDEV cluster
A WEBDEV cluster is a set of servers (or server farm)......
HErrorDuplicates (Example)
Usage example of the HErrorDuplicates function
Encryption (Property)
The Encryption property gets and sets the encryption algorithm used.
Project dashboard
The project dashboard provides an overall view of project status via different widgets.......