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...
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 functions
Several HFSQL functions are used to manage the HFSQL Client/Server data...
How to backup HFSQL Client/Server databases?
The backup of the HFSQL Client/Server databases can be performed ...
Managing rights on HFSQL Client/Server
To ensure data security and confidentiality, some actions may be restricted to a group of users...
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...
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 (prefix syntax)
Several HFSQL functions are used to manage the HFSQL Client/Server data...
HFSQL Client/Server: Scheduled tasks
The scheduled tasks are used to schedule automatic tasks...
HFSQL Client/Server: Backing up databases
Like for any database, backups of your HFSQL Client/Server databases must be performed on a regular basis...
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.
Authentication via Active Directory
Kerberos is an authentication mode based on the use of tickets and secret keys...
<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.
HAddScheduledOptimization (Function)
Adds an optimization task of HFSQL Client/Server tables.
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 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...
<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.
Overview of HFSQL Cluster
HFSQL Cluster is a database server intended to be deployed on several servers...
Managing the load balancing (dynamic load balancing on server)
The server that is hosting a HFSQL database engine can be very busy...
Debugging a connection to an HFSQL server
The stored procedures and the triggers are debugged from the environment, with real execution on the server...
<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.
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.
Using the Control Centers in Client/Server mode
All the Control Centers provided with WINDEV, WEBDEV and WINDEV Mobile use the same database...
Installing and configuring HFSQL Cluster
Required configuration and overview for installing 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.
<Connection variable>.AddScheduledOptimization (Function)
Adds an optimization task of HFSQL Client/Server tables.
1. Components provided with WINDEV
WINDEV is provided with projects that contain components....
Handling a Check Box control through programming
WINDEV, WINDEV Mobile and WEBDEV allow you to handle a Check Box control through programming......
TableDisplay (Function)
Refreshes a Table or TeeeView Table control from a given position: for a control linked to a file: changes made in the linked data file are reflected in the control. for a control handled programmatically: the calculated columns are re-calculated....
Toast (Variable type)
The Toast type is used to define all the advanced characteristics of a toast notification.
Automatic Application Features (AAF) constants
List of constants used by the Automatic Application Features (AAF) functions....
Generating the LDM from the CDM
To associate a CDM (Conceptual Data Model) with a project, you must generate the associated LDM (Logical Data Model)......
Logical operators
The logical operators are as follows......
MDL file (kept for backward compatibility): Pattern description
The MDL file is the file used to generate a RAD window......
ODBCPassword (Property)
The ODBCPassword property is used to: Identify the password used to connect to a database via an ODBC driver or a Native Connector. Specify the password used to connect to a database via an ODBC driver or a Native Connector....
Adapting a website to support multiple languages
WEBDEV Tutorial - Managing multiple languages in a website Adapting a website to support multiple languages - 50 min
Native Sybase Connector: Running the same stored procedure several times
In some cases, it may be useful to execute the same stored procedure multiple times by changing one or more parameters......
Native Sybase Connector: Output value of a stored procedure run on the server
The Native Sybase Connector (also called Native Sybase Access) is used to: specify the input values during the call to a stored procedure. retrieve the output values after a call to a stored procedure....
Text editing (Code editor)
When developing a new feature, it may be useful to keep the same environment for opening text files... Warning This feature is only available in WINDEV Suite SaaS 2025 Update 2. For more details, see Use the new features of WINDEV Suite SaaS 2025....
Print technical documentation
You can print different technical documentations describing all the elements of the project (windows, pages, reports, data files, items, components, assemblies, Custom-Folders, etc.)......
Manipulating Radio Button controls programmatically
WINDEV, WEBDEV and WINDEV Mobile allow you to programmatically manipulate Radio Button controls......
Adapting an application to support multiple languages
WINDEV Tutorial - Managing multiple languages Adapting an application to support multiple languages - 20 min
Native Oracle Connector: Running the same query several times
In some cases, it may be useful to run the same query multiple times while modifying one or more parameters......