ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

4. HFSQL Classic
Implementing the log process in an application
Regardless of the data files used by your application (HFSQL Classic or HFSQL Client/Server), the log process can be implemented on these data files......
HFSQL: Change of name
Database parameters (Setup program)
The setup program creation wizard includes the setup of the database along with the application and suggests additional elements......
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 ...
User Groupware and Client/Server tables
Applications using the User Groupware are compatible with HFSQL databases in Client/Server mode...
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: Overview
You have the ability to create applications that access the HFSQL Client/Server databases...
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 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 functions (prefix syntax)
Several HFSQL functions are used to manage the HFSQL Client/Server data...
Using the Control Centers in Client/Server mode
All the Control Centers provided with WINDEV, WEBDEV and WINDEV Mobile use the same database...
User Groupware and Client/Server tables
An application that uses the User Groupware can be used with an HFSQL database in Client/Server mode...
Keep-alive on connection
SCM: Management of rights
It is possible to manage and grant certain access rights to the developers for each element in the SCM......
Compressing frames (DSL, 3G, Edge, VPN, ...)
A frame is a packet ot data that flows through the network......
Client/Server: Connecting client computers to the server
In order for the application to be able to handle the tables found on the HFSQL server, the connection that will be used by the application must be defined in the project......
License agreement - HFSQL Client/Server
HFSQL Client/Server: Configuring the server
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: Scheduled optimization
Scheduled optimization is a mechanism for automatically optimizing your database......
HFSQL Client/Server: Managing the ports
The ports used by the HFSQL Client/Server server......
HFSQL Client/Server: Scheduled tasks
The scheduled tasks are used to schedule automatic tasks......
Managing the HFSQL servers
The HFSQL Control Center allows you to fully manage HFSQL servers......
HFSQL Cluster functions
The following functions are used to manage an HFSQL cluster
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.
Managing the load balancing (dynamic load balancing on server)
The server that is hosting a HFSQL database engine can be very busy...
<Connection variable>.SendMessageToClient (Function)
Displays a message on the client computers.
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.
Unalterable tables
This feature is used to signal that a table cannot be modified after writing...
HSendMessageToClient (Function)
Displays a message on the client computers.
<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.
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...
HCheckUnaltered (Function)
Checks that one or all records in an unalterable table have not been modified (e.g. with a hexadecimal editor).
<Source>.CheckUnaltered (Function)
Checks that one or all records in an unalterable table have not been modified (e.g. with a hexadecimal editor).
WDLog: Backup of HFSQL tables
WDLog allows you to save all the HFSQL tables used by a WINDEV or WEBDEV application...
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 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.
<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.
HManageServerUpdate (Function)
Allows you to manage the automatic update of HFSQL Client/Server servers and to define how often to check for updates.
<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.
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.