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.
TimestampType (Property)
The TimestampType property is used to: Find out the type of timestamp for an item. This item was defined in the data model editor or through programming. Define the type of timestamp for a Date, Time or DateTime item (when describing the item through programming)....
HJSONToRecord (Function)
Imports JSON data into the current record.
GDPR (Property)
The GDPR property is used to: find out if the GDPR applies to an item from a data file. define whether the GDPR should apply to an item (in the item description in the code only)....
HExecuteQueryAsynchronous (Function)
Executes a SELECT query asynchronously.
PersistedCalculatedItem (Property)
The PersistedCalculatedItem property is used to: Find out whether the value of a calculated item is stored in the data file. This item was defined in the data model editor or through programming. Define whether the value of a calculated item is stored in the data file (when describing the item through programming)....
<Source>.CheckUnaltered (Function)
Checks whether one or all records in an unalterable data file have not been modified (with an hexadecimal editor for example).
HRecordToXML (Function)
Retrieves the structure and the value of the current record and exports them into a character string in XML format.
HSeek (Function)
Positions on the first record of the data file whose value for a specific item is greater than or equal to a sought value (generic search by default).
HChangeRplDir (Function)
Modifies the location for the description of subscriber replica (RPL file).
HMode (Function)
Changes the mode and the method for locking data files.
HDeactivateAutoFilter (Function)
Disables an automatic filter on the linked files when browsing an XML file.
Chart control properties
A Chart control can be used......
HDeclare (Function)
Declares a description of data file (found in an analysis) in the current project.
HDBOpen (Function)
Opens the xBase data file and the "memo" file if it exists.
HRetrieveRecord (Function)
Returns the content of the current record (in a file, a view or a query, ...).
HChangeName (Function)
Modifies the physical name of a data file.
SQLNext (Function)
Positions on the next row of the query result.
Salesforce functions
List of Salesforce functions...
SQLPrevious (Function)
Positions on the previous row of the query result.
SQLGetMemo (Function)
Retrieves the content of a Memo column from the query result, for the current row.
KeyExpression (Property)
The KeyExpression property is used to set the different components of a composite key.
Caption (Property)
In a database, the Caption property is used to: Find out the caption associated with a file item. Find out the caption associated with a data file. Find out and modify the connection caption. In a report, the Caption property is used to: Find out the text displayed in a Static or Link control. Modify the text displayed in a Static or Link control. In a window or page, the Caption property is also used to: Find out and modify the caption of a control in a window or in a page. Find out and modify the caption of a menu option. Find out and modify the title of a window or page. Find out the content of a Breadcrumb control....
HCreateMovableReplica (Function)
Creates a movable replication.
HTriggerRecordBefore (Function)
Retrieves the value of the current record before the trigger(s) are executed.
Configuring the SOAP administrator