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>.Write (Function)
Writes a record into a data file without updating the indexes corresponding to all keys used in the file.
<Source>.RetrieveRecord (Function)
Returns the content of the current record (in a file, a view or a query, ...).
<Source>.ListQueryParameter (Function)
Returns the list of parameters for a query created in the query editor.
<Source>.Declare (Function)
Declares a description of data file (found in an analysis) in the current project.
<Source>.Modify (Function)
Modifies the specified record or the record found in memory in the data file (query or view).
<Source>.RetrieveItem (Function)
Returns the content of an item found in the current record (in the data file, view, query, ...).
<Source>.CheckIndex (Function)
Checks whether the data found in the index file (.NDX file) properly refers the data found in the data file (.FIC file).
<Source>.ToItem (Function)
Assigns the specified value to an item of the current record.
HSetTrigger (Function)
Enables or disables the management of triggers.
HCancelAlias (Function)
Cancels an alias that was declared beforehand by HAlias.
<Source>.Save (Function)
Modifies the current record if it exists, otherwise adds a new record.
HSave (Function)
Modifies the current record if it exists, otherwise adds a new record.
<Connection variable>.CloseConnection (Function)
Closes a connection to a database.
HFree (Function)
Transforms the crossed records (HCross) into deleted records.
HListQueryParameter (Function)
Returns the list of parameters for a query created in the query editor.
HBuildKeyValue (Function)
Builds the value of a composite key to implement a filter (HFilter) or to perform a search (HReadSeekFirst, HReadSeekLast, etc.).
HInfoAnalysis (Function)
Returns information about a database schema (WDD file).
HCancelSeek (Function)
Cancels the current search criterion.
<Source>.ErrorModification (Function)
Returns the value of a record item when a modification conflict occurs..
HOpen (Function)
Opens a table.
SQLLast (Function)
Sets the position on the last row of the query result.
HRecordToJSON (Function)
Retrieves the structure and value of the current record and exports them into a string in JASON format.
httpRequest (Variable type)
The httpRequest type is used to retrieve the advanced characteristics of an HTTP/HTTPS request....