ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

Managing rights on HFSQL Client/Server
To ensure data security and confidentiality, some actions may be restricted to a group of users...
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...
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...
How to backup HFSQL Client/Server databases?
The backup of the HFSQL Client/Server databases can be performed ...
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...
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...
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...
HFSQL Client/Server functions (prefix syntax)
Several HFSQL functions are used to manage the HFSQL Client/Server data...
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>.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.
HAddScheduledOptimization (Function)
Adds an optimization task of HFSQL Client/Server tables.
<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.
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...
Installing and configuring HFSQL Cluster
Required configuration and overview for installing 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.
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...
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, ...
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.
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 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.
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.
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.
The triggers
A trigger is a WLanguage procedure automatically called by the HFSQL engine whenever a modification is performed (addition, deletion, modification, ......
NbDescribedThumbnail (Property)
The NbDescribedThumbnail property is used to get the number of thumbnails expected for an item.
MaxThumbnailHeight (Property)
The MaxThumbnailHeight property gets and sets the maximum height of a thumbnail of an Image item (binary memo).
MaxThumbnailWidth (Property)
The MaxThumbnailWidth property is used to get or change the maximum width of a thumbnail of an Image item (binary memo).
WEBDEV site deployment: automatic modification of tables
The automatic modification of the tables allows updating the description of tables on the Web server......
HCheckIndex (Function)
Checks whether the data found in the index file (.NDX file) properly refers the data found in the data file (.FIC file).
NbThumbnail (Property)
The NbThumbnail property is used to get the number of thumbnails generated for an item.
Frequently asked questions about HFSQL Cluster
Frequently asked questions about HFSQL Cluster....
Installing the HFSQL Server module
Cherche les éléments d'un noeud HTML correspondant à une balise....
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).
HCheckUnaltered (Function)
Checks that one or all records in an unalterable table have not been modified (e.g. with a hexadecimal editor).
HStatCalculate (Function)
Performs various statistical calculations on the file keys.
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.
Data model editor: Describing a connection
Any program developed with WINDEV, WEBDEV or WINDEV Mobile can easily access......
HCheckMemo (Function)
Checks the structural integrity of memos in an HFSQL data file.
WEBDEV 2024 Tutorial - Table of contents
WINDEV 2024 Tutorial - Table of contents