ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

HFSQL Client/Server functions
Several HFSQL functions are used to manage the HFSQL Client/Server data...
User Groupware and Client/Server tables
Applications using the User Groupware are compatible with HFSQL databases in Client/Server mode...
How to backup HFSQL Client/Server databases?
The backup of the HFSQL Client/Server databases can be performed ...
Restoring an HFSQL Client/Server database
A backup of an HFSQL Client/Server database can be restored at any time...
User Groupware and Client/Server tables
An application that uses the User Groupware can be used with an HFSQL database in Client/Server mode...
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...
HFSQL Client/Server database: Recommendations
This help page presents the main recommendations for optimizing the security and performance of an HFSQL Client/Server database according to the constraints and desired features...
HFSQL Client/Server: Backing up databases
Like for any database, backups of your HFSQL Client/Server databases must be performed on a regular basis...
HFSQL Client/Server: Overview
You have the ability to create applications that access the HFSQL Client/Server databases...
Using the Control Centers in Client/Server mode
All the Control Centers provided with WINDEV, WEBDEV and WINDEV Mobile use the same database...
HFSQL Client/Server functions (prefix syntax)
Several HFSQL functions are used to manage the HFSQL Client/Server data...
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.
Unalterable tables
This feature is used to signal that a table cannot be modified after writing...
<HFSQL connection>.StatCalculateAsynchronous (Function)
Gets various statistics on the keys of an HFSQL Client/Server table.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
Managing the load balancing (dynamic load balancing on server)
The server that is hosting a HFSQL database engine can be very busy...
<HFSQL connection>.ReindexAsynchronous (Function)
Rebuilds the index of an HFSQL Client/Server table (".NDX" file). This operation is asynchronous, i.e., it is performed on the server and does not block the client side.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
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, ...
<Source>.CheckUnaltered (Function)
Checks that one or all records in an unalterable table have not been modified (e.g. with a hexadecimal editor).
HCheckUnaltered (Function)
Checks that one or all records in an unalterable table have not been modified (e.g. with a hexadecimal editor).
HFSQL Cluster functions
The following functions are used to manage an HFSQL cluster
<Connection variable>.SendMessageToClient (Function)
Displays a message on the client computers.
<HFSQL connection>.CheckIndexAsynchronous (Function)
Checks that the data contained in the index file (.NDX file) correctly references the data contained in the HFSQL Client/Server table (.FIC file).
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
WDLog: Backup of HFSQL tables
WDLog allows you to save all the HFSQL tables used by a WINDEV or WEBDEV application...
HCheckMemoAsynchronous (Function)
Checks the structural integrity of memos in an HFSQL Client/Server table.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
Remote HFSQL Administrator: Overview
The remote HFSQL administrator is a WEBDEV site installed with the WEBDEV application server and used to remotely manage the HFSQL Client/Server databases installed on the Web server...
HReindexAsynchronous (Function)
Rebuilds the index of an HFSQL Client/Server table (".NDX" file). This operation is asynchronous, i.e., it is performed on the server and does not block the client side.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
HSendMessageToClient (Function)
Displays a message on the client computers.
HStatCalculateAsynchronous (Function)
Gets various statistics on the keys of an HFSQL Client/Server table.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
<HFSQL connection>.CheckMemoAsynchronous (Function)
Checks the structural integrity of memos in an HFSQL Client/Server table.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
HCheckIndexAsynchronous (Function)
Checks that the data contained in the index file (.NDX file) correctly references the data contained in the HFSQL Client/Server table (.FIC file).
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
Specific features of the applications for iPhone/iPad
Monitoring robot: Configuring the Robot controller parameters
From the monitor, you can change the configuration options......
HSynchronizeReplica (Function)
Synchronizes master and subscriber replicas: operations performed on one replica are transferred to the other.
Replication options (ReplicEdit)
Creating a replication with ReplicEdit allows you to specify several parameters......
Logical Data Model (LDM)
A Logical Data Model (LDM) is used to describe the data structures (files, items, ......
Project description: Tables tab
The project description window allows you to configure various elements of your project......
Link Description (Variable type)
A Link Description variable is used to describe a link between two tables programmatically.
WDOptimizer: Optimizing indices
WDOptimizer includes multiple modes to optimize indices......
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....
Developing applications in Universal Windows 10 App mode
WINDEV and WINDEV Mobile allow you to develop applications for Windows 10 tablets and for Windows Phone 10 and Windows 10 phones (Universal Windows 10 App applications)......
Project Management Hub: Overview
The Project Management Hub is used to organize and schedule a project, from design to delivery......
HFSQL Control Center: Managing scheduled elements
You have the ability to define scheduled elements on the HFSQL server....
Installing the robot controller
The monitoring robot includes three executables......
HOnError (Function)
Customizes the management of HFSQL errors.
SCM: History search
History search allows you to perform an advanced search in the history of operations performed in the SCM......
Assisted universal replication: specific features
Installing a WEBDEV cluster
A WEBDEV cluster is a set of servers (or server farm)......
Installing the monitoring robot
The monitoring robot includes three executables......