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.
HListTrigger (Function)
Returns the list of triggers applied to one or more HFSQL tables.
HLinkMemo (Example)
Usage example of the HLinkMemo function
HModify (Function)
Modifies the specified record or the record found in memory in the table (query or view).
Thumbnail (Property)
The Thumbnail property is used to: get the value of an item thumbnail. This item was defined in the data model editor or programmatically. get and change the image associated with a Thumbnail control....
HCheckUnaltered (Function)
Checks that one or all records in an unalterable table have not been modified (e.g. with a hexadecimal editor).
HDeclareExternal (Function)
Temporarily imports into the current analysis the description of a data file from an existing HFSQL data file.
HError (Function)
Returns the number of the last error triggered by the HFSQL engine.
HFileExist (Example)
Usage example of the HFileExist function
Automatic table modification
The automatic table modification updates the description of tables on user computers......
HExtractMemo (Example)
Usage example of the HExtractMemo function
<Connection variable>.FileExist (Function)
Finds out if a file exists, i.e. if it has been physically created (HCreate or HCreationIfNotFound).
HStatCalculate (Function)
Performs various statistical calculations on the file keys.
HExtractMemo (Function)
Extracts the content of a binary memo item from an HFSQL file, a query or an HFSQL view to a physical file (on disk).
Defining specific character sets in HFSQL tables
When an application displays or saves data in HFSQL tables, this data is typed in the current language......
HFileExist (Function)
Determines: whether a file exists, which means whether it was physically created (HCreation or HCreationIfNotFound). whether a view or a query was defined....
HCreationIfNotFound (Function)
Performs the following operations: If the table doesn't exist, create an empty table (file with ".FIC" extension) with the index file, the full-text index file and the memo file if necessary. The function is equivalent to HCreation. If the table exists, opens the table....
HChangeKey (Example)
Usage example of the HChangeKey function
SQLConnectWS (Function)
Connects the current application to a database that will be queried by SQL through a Webservice proxy (SOAP).