ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

5. HFSQL Client/Server
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....
<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....
HListScheduledBackup (Function)
Lists the full and differential backups that have been scheduled on HFSQL Client/Server....
HAddScheduledOptimization (Function)
Adds an optimization task of HFSQL Client/Server data files....
<Connection variable>.AddScheduledOptimization (Function)
Adds an optimization task of HFSQL Client/Server data files....
<Connection variable>.ListScheduledBackup (Function)
Lists the full and differential backups that have been scheduled on HFSQL Client/Server....
HSetCache (Function)
Used to configure the management of caches in the HFSQL Client/Server engine....
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>.ChangePassword (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....
<Connection variable>.ModifyDatabaseRights (Function)
Modifies the rights granted to a user or to a group for a HFSQL Client/Server database....
HChangePassword (Function)
Changes the password of an HFSQL Classic or HFSQL Client/Server data file....
HDeleteScheduledOptimization (Function)
Deletes a scheduled optimization task from HFSQL Client/Server data files....
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...
Installing an HFSQL Client/Server server with an application
When creating the setup program of a WINDEV application using HFSQL Client/Server tables, the wizard allows you to...
HFSQL Client/Server functions
Several HFSQL functions are used to manage the HFSQL Client/Server data...
User Groupware and Client/Server tables
An application using User Groupware can be used with a HyperFileSQL 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...
Managing the load balancing (dynamic load balancing on server)
The server that is hosting a HFSQL database engine can be very busy...
<Connection variable>.SendMessageToClient (Function)
Displays a message on the client computers.
<HFSQL connection>.CheckMemoAsynchronous (Function)
Checks the structural integrity of memos in an HFSQL Client/Server table.
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 table (.FIC 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 table (.FIC file).
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
WDLog: Backup of HFSQL tables
WDLog allows you to save all the HFSQL tables used by a WINDEV or WEBDEV application...
HReindexAsynchronous (Function)
Rebuilds the index of an HFSQL Client/Server table (".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.
HManageServerUpdate (Function)
Allows you to manage the automatic update of HFSQL Client/Server servers and to define how often to check for 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.
HSendMessageToClient (Function)
Displays a message on the client computers.
<HFSQL connection>.ReindexAsynchronous (Function)
Rebuilds the index of an HFSQL Client/Server table (".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 table.
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 table.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
HCheckMemoAsynchronous (Function)
Checks the structural integrity of memos in an HFSQL Client/Server table.
This function is only available in subscription-based versions, starting with WINDEV Suite 2025 - Update 2.
1
2
3
4
5
6
24
>