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.
NbDescribedThumbnail (Property)
The NbDescribedThumbnail property is used to get the number of thumbnails expected for an item.
HReadSeek (Example)
Usage example of the HReadSeek function
HCreateView (Example)
Usage example of the HCreateView function
MaxThumbnailHeight (Property)
The MaxThumbnailHeight property gets and sets the maximum height of a thumbnail of an Image item (binary memo).
HDelete (Function)
Deletes a record from a table (query or view).
HDescribeTrigger (Function)
Adds or modifies a trigger on an HFSQL table.
MaxThumbnailWidth (Property)
The MaxThumbnailWidth property is used to get or change the maximum width of a thumbnail of an Image item (binary memo).
NbThumbnail (Property)
The NbThumbnail property is used to get the number of thumbnails generated for an item.
HForward (Example)
Usage example of the HForward function
HSetPosition (Example)
Usage example of the HSetPosition function
HError (Function)
Returns the number of the last error triggered by the HFSQL engine.
HExecuteQuery (Function)
Declares a query created in the query editor to the HFSQL engine and runs this query.
HListFile (Function)
Returns the list of files: found in the current analysis or in a specific analysis recognized by the HFSQL engine. The files defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account. available on a connection via a native access or via an OLE DB driver. for a group of files defined in the data model editor....
InfoThumbnailGeneration (Property)
The InfoThumbnailGeneration property is used to determine if the thumbnails of an item have been generated successfully.
HDeclareExternal (Function)
Temporarily imports into the current database schema the description of a table from an existing HFSQL table.
HExtractMemo (Function)
Extracts the content of a binary memo item from an HFSQL table, from a query or from an HFSQL view into a physical file (on disk).
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.