ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

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...
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: Port management
The ports used by the HFSQL Client/Server server...
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...
Restoring an HFSQL Client/Server database
A backup of an HFSQL Client/Server database can be restored at any time...
Managing rights on HFSQL Client/Server
To ensure data security and confidentiality, some actions may be restricted to a group of users...
How to backup HFSQL Client/Server databases?
The backup of the HFSQL Client/Server databases can be performed ...
HFSQL Client/Server functions (prefix syntax)
Several HFSQL functions are used to manage the HFSQL Client/Server data...
HFSQL Client/Server functions
Several HFSQL functions are used to manage the HFSQL Client/Server data...
HFSQL Control Center: Open an analysis
The HFSQL Control Center allows you to fully manage an analysis......
HImportText (Function)
Imports a Text file into a data file in HFSQL Classic or Client/Server format (data file described in the data model editor, or declared by HDeclare, HDeclareExternal or HDescribeFile)....
<Source>.ImportXLS (Function)
Imports an XLS file into a data file in HFSQL Classic or Client/Server format (data file described in the data model editor, or declared by HDeclare, HDeclareExternal or HDescribeFile)....
<Source>.ImportText (Function)
Imports a Text file into a data file in HFSQL Classic or Client/Server format (data file described in the data model editor, or declared by HDeclare, HDeclareExternal or HDescribeFile)....
HImportXLS (Function)
Imports an XLS file into a data file in HFSQL Classic or Client/Server format (data file described in the data model editor, or declared by HDeclare, HDeclareExternal or HDescribeFile)....
Examples for using the OLE DB provider for HFSQL
HRecordDate (Function)
Returns the date and time of the last write operation performed on a record in an HFSQL file (Classic or Client/Server)....
OLE DB driver for HFSQL Classic and HFSQL Client/Server - License agreement
ODBC driver for HFSQL Classic and HFSQL Client/Server - License agreement
Control Centers: Working in offline mode
When working on a laptop computer or on an offline computer, you may want to continue working with the data found in the Control Centers (schedule management, quality management, etc....
Log-based replication
The replication is the operation allowing you to keep updated remote databases of identical structures on which several operations are performed......
HFSQL Control Center: Overview
The HFSQL Control Center is used to manage the different HFSQL databases (Network, Mobile, Client/Server) found in the company......
Working with the Source Code Manager
The principle for working with the Source Code Manager is as follows......
The source code manager
WINDEV, WEBDEV and WINDEV Mobile propose a sophisticated Source Code Manager......
<HFSQL connection>.CheckMemoAsynchronous (Function)
Checks the structural integrity of memos in an HFSQL Client/Server data file.
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...
HCheckMemoAsynchronous (Function)
Checks the structural integrity of memos in an HFSQL Client/Server data file.
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 data file.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
Debugging a connection to an HFSQL server
The stored procedures and the triggers are debugged from the environment, with real execution on the server...
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 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...
HAddScheduledOptimization (Function)
Adds an optimization task of HFSQL Client/Server data files.
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 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...
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, ...
Authentication via Active Directory
Kerberos is an authentication mode based on the use of tickets and secret keys...
Limitations of WINDEV, WEBDEV and WINDEV Mobile
<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 function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
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 data file (.FIC file).
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
<Connection variable>.AddScheduledOptimization (Function)
Adds an optimization task of HFSQL Client/Server data files.
HStatCalculateAsynchronous (Function)
Gets various statistics on the keys of an HFSQL Client/Server data file.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
Report based on a data file
A report based on a data file is used to print the records coming from a single data file (HFSQL Classic or Client/Server, accessed via a Native Access, ......
Report based on an HFSQL view
A report based on an HFSQL view is used to print records from an HFSQL Classic or Client/Server view......
Application triggers
...A trigger is a WLanguage procedure automatically called by the HFSQL engine whenever a modification is performed (addition, deletion, modification, ...) on a record of a data file....
Custom-Folders in the analysis
Several file descriptions can be grouped into a "Custom-Folder"......
LINUX: Accessing the ODBC databases
The native access to HFSQL Classic and Client/Server is available for the WINDEV applications running in Linux ("console" applications) and for the WEBDEV sites hosted in Linux......
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......
Operating mode of HFSQL application
A HFSQL application can operate in network mode or in Client/Server mode......
Universal replication
The purpose of universal replication is to keep several databases synchronized......
HClient structure
The HClient structure is used to......
OLE DB provider for HFSQL
The OLE DB provider on HFSQL is used to access an HFSQL database (Classic or Client/Server) from an external software that manages the accesses by OLE DB......
1
4
5
6
7
8
70
>