ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

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...
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...
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...
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: Overview
You have the ability to create applications that access the HFSQL Client/Server databases...
User Groupware and Client/Server tables
An application that uses the User Groupware can be used with an HFSQL database in Client/Server mode...
HFSQL Client/Server: Backing up databases
Like for any database, backups of your HFSQL Client/Server databases must be performed on a regular basis...
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.
<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.
Unalterable tables
This feature is used to signal that a table cannot be modified after writing...
<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.
Managing the load balancing (dynamic load balancing on server)
The server that is hosting a HFSQL database engine can be very busy...
<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.
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.
HSendMessageToClient (Function)
Displays a message on the client computers.
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>.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, ...
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.
HImportHF55 (Function)
Imports a Hyper File 5.5 file into an HFSQL Classic file.
InfoThumbnailGeneration (Property)
The InfoThumbnailGeneration property is used to determine if the thumbnails of an item have been generated successfully.
<Connection variable>.FileExist (Function)
Finds out if a file exists, i.e. if it has been physically created (HCreate or HCreationIfNotFound).
Thumbnail (Property)
The Thumbnail property is used to: get the value of an item thumbnail. This item was defined in the data model editor or programmatically. get and change the image associated with a Thumbnail control....
<Connection variable>.RegenerateFile (Function)
Regenerates a table from its log.
WEBDEV 2024 Tutorial - Table of contents
WINDEV 2024 Tutorial - Table of contents
Reports & Queries software: WLanguage functions not supported
Some WLanguage functions are not available in Reports & Queries......
<Source>.ListLink (Function)
Returns the list of links (Merise) in the current database schema or in a specific database schema.
HTransactionInProgress (Function)
Used to find out whether a transaction is in progress.
The Control Centers
Control Centers provide a global vision of a given area, whether on the development phase, on an operating site, or on application maintenance or improvement......
Installing the HFSQL Server module
Cherche les éléments d'un noeud HTML correspondant à une balise....
Compression (Property)
The Compression property gets and sets the data compression mode.
SCM administrator: Available tools
The "Tools" tab in the SCM administrator allows you to......
The triggers
A trigger is a WLanguage procedure automatically called by the HFSQL engine whenever a modification is performed (addition, deletion, modification, ......