ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

Using the Control Centers in Client/Server mode
All the Control Centers provided with WINDEV, WEBDEV and WINDEV Mobile use the same database...
Restoring an HFSQL Client/Server database
A backup of an HFSQL Client/Server database can be restored at any time...
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: Overview
You have the ability to create applications that access the HFSQL Client/Server databases...
User Groupware and Client/Server data files
An application using User Groupware can be used with a HyperFileSQL 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...
HFSQL Client/Server functions (prefix syntax)
Several HFSQL functions are used to manage the HFSQL Client/Server data...
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 data files
An application that uses the User Groupware can be used with an HFSQL database in Client/Server mode...
How to backup HFSQL Client/Server databases?
The backup of the HFSQL Client/Server databases can be performed...
HFSQL Client/Server functions
Several HFSQL functions are used to manage the HFSQL Client/Server data...
HCheckUnaltered (Function)
Checks that one or all records in an unalterable data file have not been modified (e.g. with a hexadecimal editor).
<HFSQL connection>.StatCalculateAsynchronous (Function)
Gets various statistics on the keys of an HFSQL Client/Server data file.
This new function is available from WINDEV Suite SaaS 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 new function is available from WINDEV Suite SaaS 2025 - Update 2.
Unalterable data files
This feature is used to signal that a data file cannot be modified after writing...
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 new function is available from WINDEV Suite SaaS 2025 - Update 2.
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 new function is available from WINDEV Suite SaaS 2025 - Update 2.
HSendMessageToClient (Function)
Displays a message on the client computers.
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>.CheckMemoAsynchronous (Function)
Checks the structural integrity of memos in an HFSQL Client/Server data file.
This new function is available from WINDEV Suite SaaS 2025 - Update 2.
HFSQL Cluster functions
The following functions are used to manage an HFSQL cluster
HStatCalculateAsynchronous (Function)
Gets various statistics on the keys of an HFSQL Client/Server data file.
This new function is available from WINDEV Suite SaaS 2025 - Update 2.
<Connection variable>.SendMessageToClient (Function)
Displays a message on the client computers.
HCheckMemoAsynchronous (Function)
Checks the structural integrity of memos in an HFSQL Client/Server data file.
This new function is available from WINDEV Suite SaaS 2025 - Update 2.
WDLog: Backup of HFSQL data files
WDLog allows you to save all the HFSQL data files used by a WINDEV or WEBDEV application...
<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 new function is available from WINDEV Suite SaaS 2025 - Update 2.
<Source>.CheckUnaltered (Function)
Checks that one or all records in an unalterable data file have not been modified (e.g. with a hexadecimal editor).
HCreateView (Function)
Creates an HFSQL view. This function uses the former view mechanism....
Data source (Type of variable)
A Data source variable is used to describe a temporary data source (query, view, alias, ...)
HExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
12. Retrieving data from a site
SCM administrator: Managing the repository
The SCM administrator (Source Code Manager) allows you to directly handle the source codes of different projects included in the Source Code Manager......
WX file
The "Executable Name".WX file is used to manage some features directly, even if these features have not been included in the application. This file is found beside the executable....
Native SQL Server Connector for WINDEV and WEBDEV
WINDEV and WEBDEV support an optional Native SQL Server Connector (also called Native SQL Server Access)......
Constants for managing errors and exceptions
List of constants used by the functions for managing errors and exceptions....
1. Creating a WEBDEV project and its analysis
WEBDEV Tutorial - Creating a WEBDEV project and its analysis Lesson 1 - Creating a WEBDEV project and its analysis - 5 min
1. Creating a WINDEV project and its analysis
WINDEV Tutorial: Creating a WINDEV project and its analysis Lesson 1 - Creating a WINDEV project and its analysis - 5 min
The setup editor WDInst
WDInst is a setup editor used to define the setup parameters of your application......
5. User Groupware in practice
The options of the User Groupware
An application is often intended to be used by several users connected via a network......
Overview of HFSQL Cluster
HFSQL Cluster is a database server intended to be deployed on several servers......
Analysis: Describing data files
The analysis is used to define the structure of data files used by the project......
File Description (Type of variable)
The File Description variable is used to programmatically describe data files.
Automated tests on an executable
WINDEV proposes to run the different project tests directly on the corresponding executable......
HExecuteQuery (Function)
Declares a query created in the query editor to the HFSQL engine and runs this query.
Monitoring robot: Configuring the robot parameters
From the monitor, you can change the configuration options......
WINDEV, WEBDEV and WINDEV Mobile tools
The following tools are provided with WINDEV, WEBDEV and WINDEV Mobile...
Overloading a WLanguage function or using a WLanguage function in an SQL query
WLanguage includes the "WL" keyword......
Server triggers
Server triggers are stored procedures executed by the server before or after a write operation performed on a database file......
Sharing your source code with the SCM
WINDEV Tutorial - An SCM for WINDEV Sharing your source code with the SCM - 30 min