ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

5. HFSQL Client/Server
HManageServerUpdate (Function)
Used to manage the automatic update of HFSQL Client/Server servers by specifying the check frequency regarding the availability of updates....
<Connection variable>.ManageServerUpdate (Function)
Used to manage the automatic update of HFSQL Client/Server servers by specifying the check frequency regarding the availability of updates....
HDeleteDirectory (Function)
Deletes a directory from an HFSQL Client/Server database....
<Connection variable>.ListDatabase (Function)
Lists the Client/Server databases associated with a connection....
HListDatabase (Function)
Lists the Client/Server databases associated with a connection....
<Connection variable>.DeleteDirectory (Function)
Deletes a directory from an HFSQL Client/Server database....
hScheduling (Type of variable)
The hScheduling type is used to define and find out the characteristics of the scheduling that must be performed: for a scheduled optimization task of HFSQL Client/Server files. for a scheduled backup task of HFSQL Client/Server files. for a scheduled replication of HFSQL servers....
ExtendedInfo (Property)
The ExtendedInfo property is used to get additional information: about a data file accessed by a Native Connector or HFSQL Client/Server. about an item accessed by a Native Connector or HFSQL Client/Server. about a connection. In this case, this property is equivalent to CtExtendedInfo....
<Connection variable>.ListScheduledBackup (Function)
Lists the full and differential backups that have been scheduled on HFSQL Client/Server....
<Connection variable>.AddScheduledOptimization (Function)
Adds an optimization task of HFSQL Client/Server data files....
HUpdateLink (Function)
Updates on the server all the links of an HFSQL Client/Server data file....
<Source>.InfoFile (Function)
Returns the characteristics of an HFSQL Classic or Client/Server data file....
<Source>.UpdateLink (Function)
Updates on the server all the links of an HFSQL Client/Server data file....
<Connection variable>.InfoFile (Function)
Returns the characteristics of an HFSQL Classic or Client/Server data file....
HInfoFile (Function)
Returns the characteristics of an HFSQL Classic or Client/Server data file....
HSetCache (Function)
Used to configure the management of caches in the HFSQL Client/Server engine....
HAddScheduledOptimization (Function)
Adds an optimization task of HFSQL Client/Server data files....
HListScheduledBackup (Function)
Lists the full and differential backups that have been scheduled on HFSQL Client/Server....
<Source>.ChangePassword (Function)
Changes the password of an HFSQL Classic or HFSQL Client/Server data file....
HChangePassword (Function)
Changes the password of an HFSQL Classic or HFSQL Client/Server data file....
hBackupDescription (Type of variable)
The hBackupDescription type is used to programmatically describe an HFSQL Client/Server backup....
HDeleteScheduledOptimization (Function)
Deletes a scheduled optimization task from HFSQL Client/Server data files....
<Connection variable>.ModifyDatabaseRights (Function)
Modifies the rights granted to a user or to a group for a HFSQL Client/Server 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...
HFSQL Client/Server functions (prefix syntax)
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 ...
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 that uses the User Groupware can be used with 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...
Restoring an HFSQL Client/Server database
A backup of an HFSQL Client/Server database can be restored at any time...
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: Overview
You have the ability to create applications that access the HFSQL Client/Server databases...
User Groupware and Client/Server data files
An application using User Groupware can be used with a HyperFileSQL database in Client/Server mode...
HFSQL Client/Server: Backing up databases
Like for any database, backups of your HFSQL Client/Server databases must be performed on a regular basis...
HSendMessageToClient (Function)
Displays a message on the client computers.
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.
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>.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 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.
HFSQL Cluster functions
The following functions are used to manage an HFSQL cluster
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.
<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, ...
<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...
<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.
<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
3
4
5
6
25
>