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.
Data model editor: Describing a connection
Any program developed with WINDEV, WEBDEV or WINDEV Mobile can easily access......
<Connection variable>.RegenerateFile (Function)
Regenerates a data file from its log.
Transactions: Secure processes on HFSQL data files
This chapter presents the following topics......
Telemetry: Viewing data
To see the results of telemetry data for your applications, WINDEV and WINDEV Mobile propose a telemetry editor......
HSetIntegrity (Function)
Enables or disables the management of an integrity constraint on a file link.
Server (Property)
The Server property is used to manage servers.
HCheckMemo (Function)
Checks the structural integrity of memos in an HFSQL data file.
HRegenerateFile (Function)
Regenerates a data file from its log.
HSortView (Function)
Sorts an HFSQL view by creating an index on a view item. This function uses the former view mechanism.
HCopyFile (Example)
Usage example of the HCopyFile function
HDescribeTrigger (Function)
Adds or modifies a trigger on an HFSQL data file.
HCreationIfNotFound (Example)
Usage example of the HCreationIfNotFound function
HReadSeekFirst (Example)
Usage example of the HReadSeekFirst function
HCopyRecord (Example)
Usage example of the HCopyRecord function
Creating a replication
To understand the operating mode of ReplicEdit, we are going to create a replication by using a simple example......
HCheckIndex (Function)
Checks whether the data found in the index file (.NDX file) properly refers the data found in the data file (.FIC file).
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
NbThumbnail (Property)
The NbThumbnail property is used to get the number of thumbnails generated for an item.
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....
HSetPosition (Example)
Usage example of the HSetPosition function
HForward (Example)
Usage example of the HForward function
MaxThumbnailHeight (Property)
The MaxThumbnailHeight property is used to get and change the maximum height of a thumbnail of an Image item (binary memo).