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>.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.
<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>.ServerMaintenance (Function)
Checks and optimizes the system tables of 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>.CreationIfNotFound (Function)
Performs the following operations: If the file does not exist, creates an empty data file (".FIC" file) with the index file and the memo file if necessary. The function is equivalent to HCreation. If the file exists, opens the file....
<Source>.DuplicateRecord (Function)
Duplicates the record read in a data file: the record found in memory is added into the data file (query or view).
<Source>.Cross (Function)
Crosses a record in a data file.
<Source>.StatDate (Function)
Returns the date of the last update for the index statistics.
<Source>.First (Function)
Sets the position on the first record of a data file according to the specified browse item.
<Connection variable>.SetIntegrity (Function)
Enables or disables the management of an integrity constraint on a file link.
<Source>.Delete (Function)
Deletes a record from a data file (query or view).
<Source>.StatTime (Function)
Returns the time of the last update for the index statistics.
HStatDate (Function)
Returns the date of the last update for the index statistics.
HRplAddFile (Function)
Adds a table to a universal replication.
GeometryWithin (Function)
Determines whether geometry A is completely within geometry B (i.e., geometry B completely contains geometry A).
HStatTime (Function)
Returns the time of the last update for the index statistics.
<Source>.LockRecNum (Function)
Locks a record and restricts the access to this record for all the other applications.
<Source>.Creation (Function)
Creates an empty table (extension ".FIC") with index file, full-text index file, spatial index file, and memo file if required.
<Source>.Add (Function)
Adds: the record found in memory into the table (query or view). the record found in a Record variable into the table (query or view)....
HFilterIncludedBetween (Function)
Defines and enables an "Included between" filter on a file, view or query.