ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

Managing HFSQL Client/Server applications
The HFSQL Control Center is used to manage the HFSQL Client/Server servers and the HFSQL Client/Server databases......
gpwOpenConnection (Function)
Opens a connection to a specific Client/Server database to manage the files of user groupware in Client/Server mode....
HDeactivateServerTrigger (Function)
Disables a HFSQL Client/Server server trigger on a server....
HDeleteTask (Function)
Deletes a scheduled task from an HFSQL Client/Server server....
HDeleteScheduledBackup (Function)
Deletes a scheduled backup from an HFSQL Client/Server server....
<Connection variable>.DeactivateServerTrigger (Function)
Disables a HFSQL Client/Server server trigger on a server....
<Connection variable>.DeleteScheduledBackup (Function)
Deletes a scheduled backup from an HFSQL Client/Server server....
<Connection variable>.DeleteTask (Function)
Deletes a scheduled task from an HFSQL Client/Server server....
<Connection variable>.SetServer (Function)
Used to find out and modify some settings of HFSQL Client/Server server....
<Connection variable>.ManageTask (Function)
Enables or disables a scheduled task on an HFSQL Client/Server server....
HSetServer (Function)
Used to find out and modify some settings of HFSQL Client/Server server....
HManageTask (Function)
Enables or disables a scheduled task on an HFSQL Client/Server server....
HFSQL Client/Server: Configuring the data files on the server
HListTask (Function)
Lists the scheduled tasks of an HFSQL Client/Server server for a given connection....
HInfoBackup (Function)
Returns information about one or more backups performed on an HFSQL Client/Server server....
<Connection variable>.ListTask (Function)
Lists the scheduled tasks of an HFSQL Client/Server server for a given connection....
<Connection variable>.InfoBackup (Function)
Returns information about one or more backups performed on an HFSQL Client/Server server....
2. Managing a Client/Server database
WINDEV Tutorial: Using an HFSQL Client/Server database Lesson 2 - Managing a Client/Server database - 20 min...
1. HFSQL Client/Server: Implementation
WINDEV Tutorial: Using an HFSQL Client/Server database Lesson 1 - HFSQL Client/Server: Implementation - 10 min...
2. Managing a Client/Server database
WEBDEV Tutorial - Managing an HFSQL Client/Server database Lesson 2 - Managing a Client/Server database - 20 min...
1. Implementing a Client/Server database
WEBDEV Tutorial - Managing an HFSQL Client/Server database Lesson 1 - Implementing a Client/Server database - 10 min...
5. HFSQL Cient/Server
5. HFSQL Client/Server
A WINDEV Mobile application can also use an HFSQL database in Client/Server mode....
Using the Control Centers in Client/Server mode
All the Control Centers provided with WINDEV, WEBDEV and WINDEV Mobile use the same database...
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 functions (prefix syntax)
Several HFSQL functions are used to manage the HFSQL Client/Server data...
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...
HFSQL Client/Server: Overview
You have the ability to create applications that access the HFSQL Client/Server databases...
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...
User Groupware and Client/Server data files
An application using User Groupware can be used with a HyperFileSQL database in Client/Server mode...
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: Backing up databases
Like for any database, backups of your HFSQL Client/Server databases must be performed on a regular basis...
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.
Unalterable data files
This feature is used to signal that a data file cannot be modified after writing...
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.
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.
HSendMessageToClient (Function)
Displays a message on the client computers.
<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.
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 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 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
<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.
<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.
<Connection variable>.SendMessageToClient (Function)
Displays a message on the client computers.
HCheckUnaltered (Function)
Checks that one or all records in an unalterable data file have not been modified (e.g. with a hexadecimal editor).
WDLog: Backup of HFSQL data files
WDLog allows you to save all the HFSQL data files used by a WINDEV or WEBDEV application...
<Source>.CheckUnaltered (Function)
Checks that one or all records in an unalterable data file have not been modified (e.g. with a hexadecimal editor).
1
2
>