ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

HFConf.Ini file
The HFConf.INI file is found at server root. This file is used to define several characteristics of HFSQL Client/Server server....
Password (Property)
The Password property can be used: on the edit controls (or on the text table columns) to find out whether the control is a "Password" control or to modify the "Password" type of the control. on the connections (HFSQL Client/Server, OLE DB, etc.) to define the password of the user who uses the connection....
Source (Property)
The Source property can be used on: a Chart control: in this case, the Source property is used to get the source of the series: Table column, list of values, ... a connection: in this case, the Source property is used to get or set the source of a connection (HFSQL Client/Server, OLE DB, etc.)....
Native 64-bit and native 32-bit: a single source code
The 64-bit operating systems are starting to appear on the PCs and on the servers......
RepeatableReadSupported (Property)
The RepeatableReadSupported property is used to: Determine if the data file (defined in the data model editor or programmatically) can be used in HFSQL Client/Server in a transaction that includes a "Repeatable Read" isolation mode. Allow the use of a transaction that includes a "Repeatable Read" isolation mode for a data file (files described programmatically only)....
WDAdminHF: Saving the databases
The remote HFSQL administrator allows you to create backups of HFSQL Client/Server data files......
2. Modes to install an application
HInfoFile (Function)
Returns the characteristics of an HFSQL Classic or Client/Server table....
<Source>.InfoFile (Function)
Returns the characteristics of an HFSQL Classic or Client/Server table....
<Connection variable>.InfoFile (Function)
Returns the characteristics of an HFSQL Classic or Client/Server table....
6. HFSQL Client/Server cluster
6. HFSQL Client/Server clusters
6. HFSQL Cluster
HFSQL Cluster is an extension of the HFSQL Client/Server database model....
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...
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: Port management
The ports used by the HFSQL Client/Server server...
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 functions
Several HFSQL functions are used to manage the HFSQL Client/Server data...
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: Scheduled tasks
The scheduled tasks are used to schedule automatic tasks...
Managing rights on HFSQL Client/Server
To ensure data security and confidentiality, some actions may be restricted to a group of users...
HFSQL Client/Server functions (prefix syntax)
Several HFSQL functions are used to manage the HFSQL Client/Server data...
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...
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...
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.
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 Cluster functions
The following functions are used to manage an HFSQL cluster
<Connection variable>.AddScheduledOptimization (Function)
Adds an optimization task of HFSQL Client/Server tables.
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.
Limitations of WINDEV, WEBDEV and WINDEV Mobile
A structure is a custom type of data...
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, ...
HAddScheduledOptimization (Function)
Adds an optimization task of HFSQL Client/Server tables.
Installing and configuring HFSQL Cluster
Required configuration and overview for installing HFSQL Cluster.
Using the Control Centers in Client/Server mode
All the Control Centers provided with WINDEV, WEBDEV and WINDEV Mobile use the same database...
<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...
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>.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.
<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.
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.
Authentication via Active Directory
Kerberos is an authentication mode based on the use of tickets and secret keys...
Debugging a connection to an HFSQL server
The stored procedures and the triggers are debugged from the environment, with real execution on the server...