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 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...
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.
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.
<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.
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.
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.
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 new function is available from WINDEV Suite SaaS 2025 - Update 2.
<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.
<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
>