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.
HDeactivateAutoFilter (Function)
Disables an automatic filter on the linked files when browsing an XML file.
HMode (Function)
Changes the mode and the method for locking data files.
<Source>.DataSourceKnown (Function)
Determines if a data source has been initialized.
HDBOpen (Function)
Opens the xBase table and the "memo" file if it exists.
Unalterable (Property)
The property Unalterable property is used to set the inalterability of a table: the table cannot be modified; only additions can be made.
HChangeRplDir (Function)
Changes the location of the subscriber replica description ("*.rpl" file).
The "Database schema" pane
The "Database schema" pane shows......
HRetrieveRecord (Function)
Returns the content of the current record (in a file, a view or a query, ...).
Code editor: Various operations
The code editor is the editor where the developers spend most of their time. This help page presents a series of useful options for the most common actions ......
HChangeName (Function)
Modifies the physical name of a table.
HDeclare (Function)
Declares a description of data file (found in an analysis) in the current project.
HListCustomFolder (Function)
Returns a list of defined Custom-Folders (also called groups): in the current database schema, in ongoing database schemas (projects with multiple database schemas). in the specified database schema....
HDataSourceKnown (Function)
Determines if a data source has been initialized.
HCreateMovableReplica (Function)
Creates a movable replication.
SQLNext (Function)
Positions on the next row of the query result.
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.
HTriggerRecordBefore (Function)
Retrieves the value of the current record before the trigger(s) are executed.
Salesforce functions
List of Salesforce functions...