ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Version: 2026
HFSQL Client/Server: Scheduled tasks
The scheduled tasks are used to schedule automatic tasks...
HFSQL Client/Server functions
Several HFSQL functions are used to manage the HFSQL Client/Server data...
Managing rights on HFSQL Client/Server
To ensure data security and confidentiality, some actions may be restricted to a group of users...
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 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 (prefix syntax)
Several HFSQL functions are used to manage the HFSQL Client/Server data...
Restoring an HFSQL Client/Server database
A backup of an HFSQL Client/Server database can be restored at any time...
How to backup HFSQL Client/Server databases?
The backup of the HFSQL Client/Server databases can be performed ...
HFSQL Client/Server: Port management
The ports used by the HFSQL Client/Server server...
HFSQL Client/Server: Backing up databases
Like for any database, backups of your HFSQL Client/Server databases must be performed on a regular basis...
Limitations of WINDEV, WEBDEV and WINDEV Mobile
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, ...
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.
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 data file (.FIC 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.
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 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 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.
Overview of HFSQL Cluster
HFSQL Cluster is a database server intended to be deployed on several servers...
HAddScheduledOptimization (Function)
Adds an optimization task of HFSQL Client/Server data files.
Managing the load balancing (dynamic load balancing on server)
The server that is hosting a HFSQL database engine can be very busy...
<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.
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.
<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 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.
Debugging a connection to an HFSQL server
The stored procedures and the triggers are debugged from the environment, with real execution on the server...
Null (keyword)
The "Null" keyword can correspond to:
Size (Example)
Usage example of the Size property
HSynchronizeReplica (Example)
Usage example of the HSynchronizeReplica function
HSeekFirst (Function)
Positions on the first file record whose value for a specific item is greater than or equal to a sought value.
Test of a query
The query editor allows you to run the test of query result......
ErrorInfo (Function)
Retrieves information about the last error that occurred in a function of a WINDEV, WINDEV Mobile or WEBDEV component.
Type (Example)
Usage example of the Type property
External language: Programming in C++ (WDWDIAL interface)
This third method uses the notion of class inheritance to simplify the interfacing between a C++ application and WINDEV......
AddLink (Function)
Adds a link to a text section in an edit control.
Printing a report in WINDEV
When creating a report, the test of this report can be run from the report editor......
fRename (Function)
Modifies the name of a file.
fGlobalDirCommon (Function)
Returns a directory path for the global data of current application (data shared between several applications), regardless of the current user.
fGlobalDirUser (Function)
Returns a directory path for the global data of current application (data shared between several applications), for the current user.
RTFAddLink (Function)
Adds a link to a text section in an RTF Edit control.
Select query description window: Actions applied
This help page presents the actions that can be performed from the description window of a query....
Report with parameters
When printing a report, you have the ability to pass parameters to this report......
fWriteLine (Example)
Usage example of the fWriteLine function
HAlias (Example)
Usage example of the HAlias function
Reset (Function)
Reinitializes: all the controls found in the current window or page (including the groups of controls, the supercontrols and the internal windows). the controls found in a group of controls, a supercontrol, an internal window or an internal page....
gStoredValueEnable (Function)
Allows (or not) retrieving the value defined by gStoredValue in a List Box or a Combo Box control.
Compound statements
iPrintReport (Function)
Prints a report created with the report editor.
12. Synchronizing data
11. Table/Looper controls
gLinkActivate (Function)
Allows (or not) retrieving the value defined by gLink in a List Box or a Combo Box control. Function kept for compatibility. It is recommended to use gStoredValueEnable....
1
…
57
58
59
60
61
…
70
>