ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

HFSQL Client/Server: Scheduled tasks
The scheduled tasks are used to schedule automatic tasks...
HFSQL Client/Server functions
Several HFSQL functions are used to manage the HFSQL Client/Server data...
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 data files, 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...
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 functions (prefix syntax)
Several HFSQL functions are used to manage the HFSQL Client/Server data...
Restoring an HFSQL Client/Server database
A backup of an HFSQL Client/Server database can be restored at any time...
How to backup HFSQL Client/Server databases?
The backup of the HFSQL Client/Server databases can be performed ...
HFSQL Client/Server: Port management
The ports used by the HFSQL Client/Server server...
HFSQL Client/Server: Backing up databases
Like for any database, backups of your HFSQL Client/Server databases must be performed on a regular basis...
Limitations of WINDEV, WEBDEV and WINDEV Mobile
Using the Control Centers in Client/Server mode
All the Control Centers provided with WINDEV, WEBDEV and WINDEV Mobile use the same database...
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, ...
HCheckMemoAsynchronous (Function)
Checks the structural integrity of memos in an HFSQL Client/Server data file.
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 data file (.FIC file).
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 data file.
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...
HReindexAsynchronous (Function)
Rebuilds the index of an HFSQL Client/Server data file (".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.
Installing and configuring HFSQL Cluster
Required configuration and overview for installing HFSQL Cluster.
HFSQL Cluster functions
The following functions are used to manage an HFSQL cluster
<Connection variable>.AddScheduledOptimization (Function)
Adds an optimization task of HFSQL Client/Server data files.
Overview of HFSQL Cluster
HFSQL Cluster is a database server intended to be deployed on several servers...
HAddScheduledOptimization (Function)
Adds an optimization task of HFSQL Client/Server data files.
Managing the load balancing (dynamic load balancing on server)
The server that is hosting a HFSQL database engine can be very busy...
<HFSQL connection>.CheckMemoAsynchronous (Function)
Checks the structural integrity of memos in an HFSQL Client/Server data file.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
HStatCalculateAsynchronous (Function)
Gets various statistics on the keys of an HFSQL Client/Server data file.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
<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 data file (.FIC file).
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
<HFSQL connection>.ReindexAsynchronous (Function)
Rebuilds the index of an HFSQL Client/Server data file (".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.
Debugging a connection to an HFSQL server
The stored procedures and the triggers are debugged from the environment, with real execution on the server...
DotNetDelegate (Function)
Initializes a.NET delegate.
Creating a report
The report editor allows you to easily create all types of reports via a wizard......
H.ErrIgnore (Variable)
Specifies the mode for processing the errors: the errors are processed by WINDEV the errors are processed by the program....
Operator on Address
The & operator returns the address of a variable as an integer
ReplicSynchronize (Function)
Synchronizes the data corresponding to a replication.
Lower (Function)
Converts all characters in a string to lowercase according to the region settings defined in Windows.
Debugging in Android
All developers appreciate the possibility to debug an application directly on the device......
Currency + Euro type
In a WINDEV application or in a WEBDEV site, the Euro must be managed in all the controls used to enter or display currency values......
How to develop a PHP site?
What is a PHP site?......
11. User Macro-Code: UMC in practice
Upper (Function)
Converts all characters in a string to uppercase according to the region settings defined in Windows.
TreeInsert (Function)
Inserts a leaf into a TreeView control at a specific position.
Project dashboard
The project dashboard provides an overall view of project status via different widgets.......
Enumeration and Combination items
WINDEV, WEBDEV and WINDEV Mobile propose the Enumeration and Combination types......
WDConver : Use in command line mode
Using WDConver in command line mode consists in running a conversion description created and saved with WDConver ("......
GetDefinition (Function)
Retrieves the definition of element type.
StoreTheConfiguration (Property)
The StoreTheConfiguration property is used to: Determine whether the configuration of the panes in a dynamic Tab control or Ribbon control is automatically saved and restored. Modify the configuration of the panes in a dynamic Tab control or Ribbon control so that it is automatically saved and restored (or not)...
ParallelTaskExecute (Function)
Triggers the execution of a parallel task.
TotalNbRec (Property)
The TotalNbRec property is used to: Get the number of records to be printed. Change the number of records to be printed....
WLanguage functions available for a report
Most WLanguage functions can be used in the events of a report (created with the report editor)......
WDInst: configuring the directory of the data files and the directory of the files of user groupware
The setup editor WDInst ("Tools......
Query creation mode: independent or embedded query
The query editor proposes two methods for creating a query......
Compile (Function)
Dynamically compiles an Procedure whose source code is provided (dynamic compilation).
List of extension attributes
The list of extension attributes ......
Chart: Managing scales
In a chart, the scales are used to quickly estimate the value of different points found in a chart......