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...
HOperationInProgress (Function)
Returns the list of automatic operations in progress on an HFSQL server.
HServerMaintenance (Function)
Checks and optimizes the system tables of an HFSQL server.
<Connection variable>.ServerMaintenance (Function)
Checks and optimizes the system tables of 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 data files, the wizard allows you to...
HManageServerUpdate (Function)
Allows you to manage the automatic update of HFSQL Client/Server servers and to define how often to check for updates.
HStartServerUpdate (Function)
Used to immediately start the automatic server update.
<Connection variable>.StartServerUpdate (Function)
Used to immediately start the automatic server update.
<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.
<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.
HFSQL and Docker
Docker is a software platform that allows you to run applications in software containers on Linux (Docker runs like a daemon)...
HListServer (Function)
Lists the HFSQL servers installed on a computer.
DescribedPhysicalName (Property)
The DescribedPhysicalName property is used to manage the physical name of HFSQL data files.
PhysicalName (Property)
The PhysicalName property is used to manage the physical name of HFSQL data files.
InfoThumbnailGeneration (Property)
The InfoThumbnailGeneration property is used to determine if the thumbnails of an item have been generated successfully.
HDelete (Function)
Deletes a record from a data file (query or view).
MaxThumbnailWidth (Property)
The MaxThumbnailWidth property is used to get or change the maximum width of a thumbnail of an Image item (binary memo).
HLinkMemo (Example)
Usage example of the HLinkMemo function
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.
HCheckUnaltered (Function)
Checks whether one or all records in an unalterable data file have not been modified (with an hexadecimal editor for example).
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).
HFileExist (Example)
Usage example of the HFileExist function
Automatic data file modification
The automatic data file modification updates the description of data files on user computers......
HExtractMemo (Example)
Usage example of the HExtractMemo function
HModify (Function)
Modifies the specified record or the record found in memory in the data file (query or view).
<Connection variable>.FileExist (Function)
Finds out if a file exists, i.e. if it has been physically created (HCreation or HCreationIfNotFound).
HListTrigger (Function)
Returns the list of triggers applied to one or more HFSQL data files.
SQLConnectWS (Function)
Connects the current application to a database that will be queried by SQL through a Webservice proxy (SOAP).
HChangeKey (Example)
Usage example of the HChangeKey function
HAdd (Example)
Usage example of the HAdd function
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 through programming. get and change the image associated with a Thumbnail control....
Defining specific character sets in HFSQL data files
When an application is used to display or save data in HFSQL files, this data is entered in the current language......
HCreationIfNotFound (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....
HModify (Example)
Usage example of the HModify function
HPrepareQuery (Function)
Initializes a query and declares this query to the database server in order to optimize the next executions of this query.
SQLExec (Function)
Names and runs an SQL query.