ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

HFSQL Client/Server functions
Several HFSQL functions are used to manage the HFSQL Client/Server data...
Stored procedures and queries (HFSQL Client/Server)
The stored procedures are used to simplify the development and the maintenance of your applications by factorizing the code...
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...
How to backup HFSQL Client/Server databases?
The backup of the HFSQL Client/Server databases can be performed ...
HFSQL Client/Server: Scheduled tasks
The scheduled tasks are used to schedule automatic tasks...
Restoring an HFSQL Client/Server database
A backup of an HFSQL Client/Server database can be restored at any time...
HFSQL Client/Server: Port management
The ports used by the HFSQL Client/Server server...
Managing rights on HFSQL Client/Server
To ensure data security and confidentiality, some actions may be restricted to a group of users...
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: Backing up databases
Like for any database, backups of your HFSQL Client/Server databases must be performed on a regular basis...
HFSQL Client/Server functions (prefix syntax)
Several HFSQL functions are used to manage the HFSQL Client/Server data...
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.
<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.
Overview of HFSQL Cluster
HFSQL Cluster is a database server intended to be deployed on several servers...
<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.
<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.
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, ...
HFSQL Cluster functions
The following functions are used to manage an HFSQL cluster
Limitations of WINDEV, WEBDEV and WINDEV Mobile
A structure is a custom type of data...
<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.
Managing the load balancing (dynamic load balancing on server)
The server that is hosting a HFSQL database engine can be very busy...
Using the Control Centers in Client/Server mode
All the Control Centers provided with WINDEV, WEBDEV and WINDEV Mobile use the same database...
Debugging a connection to an HFSQL server
The stored procedures and the triggers are debugged from the environment, with real execution on the server...
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.
Authentication via Active Directory
Kerberos is an authentication mode based on the use of tickets and secret keys...
Installing and configuring HFSQL Cluster
Required configuration and overview for installing HFSQL Cluster.
HAddScheduledOptimization (Function)
Adds an optimization task of HFSQL Client/Server tables.
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.
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...
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.
<Connection variable>.AddScheduledOptimization (Function)
Adds an optimization task of HFSQL Client/Server tables.
WDLog: Backup of HFSQL tables
WDLog allows you to save all the HFSQL tables used by a WINDEV or WEBDEV application......
HSetIntegrity (Function)
Enables or disables the management of an integrity constraint on a file link.
HChangeLogDir (Function)
Modifies the location of log files corresponding to an HFSQL data file.
HIndex (Function)
Rebuilds the file index (".NDX" file).
Configuring an existing project for the SCM
Some operations are required before an existing project can be used by the Source Code Manager......
Feedback component
The Feedback component is a component provided with WINDEV......
HDeclareExternal (Function)
Temporarily imports into the current database schema the description of a table from an existing HFSQL table.
Managing databases in the WINDEV Java applications
This document presents the different access modes to databases from a WINDEV Java application......
Managing accounts
WEBDEV Account Manager allows you to create a deployment account......
Installing the monitor
The monitoring robot includes three executables......
Docker image of the WEBDEV Application Server
From with version 24, a Docker container with the WEBDEV Application Server can be found in Docker Hub......
Project description: Tables tab
The project description window allows you to configure various elements of your project......
HListFile (Function)
Returns the list of files: current database schema. database schemas in progress (projects with multiple database schemas). a specific database schema recognized by the HFSQL engine. available on a connection via a Native Connector or an OLE DB driver. for a group of files defined in the data model editor....
Specific features of iPhone/iPad applications
To simplify the reading in the controls used to view large volumes of data, the end user has the ability to zoom the data found in the control......
TablePrint (Function)
Prints the content of the specified Table control without having to create a report based on the Table control.
Logical Data Model (LDM)
A Logical Data Model (LDM) is used to describe the data structures (files, items, ......