ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

Using the Control Centers in Client/Server mode
All the Control Centers provided with WINDEV, WEBDEV and WINDEV Mobile use the same database...
How to backup HFSQL Client/Server databases?
The backup of the HFSQL Client/Server databases can be performed ...
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...
HFSQL Client/Server functions (prefix syntax)
Several HFSQL functions are used to manage the HFSQL Client/Server data...
<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.
<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.
HManageServerUpdate (Function)
Allows you to manage the automatic update of HFSQL Client/Server servers and to define how often to check for updates.
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.
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.
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.
<Connection variable>.SendMessageToClient (Function)
Displays a message on the client computers.
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>.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.
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...
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 table.
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>.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.
<Connection variable>.ListUser (Function)
Returns the list of users defined for a connection.
<Connection variable>.ListGroup (Function)
Returns the list of groups of users defined for a connection.
<Connection variable>.UpdateSet (Function)
Creates or updates a set of procedures on an HFSQL server.
<Connection variable>.InfoGroup (Function)
Returns information about the specified group of users.
<Connection variable>.InfoTask (Function)
Returns the characteristics of a scheduled task in a hScheduledTask variable].
<Connection variable>.ModifyUser (Function)
Modifies the information about a user according to the elements found in the corresponding variables for user management.
Universal replication
The purpose of universal replication is to keep several databases synchronized......
HUpdateSet (Function)
Creates or updates a set of procedures on an HFSQL server.
HModifyUser (Function)
Modifies the information about a user according to the elements found in the corresponding variables for user management.
HInfoTask (Function)
Returns the characteristics of a scheduled task in a hScheduledTask variable].
HInfoGroup (Function)
Returns information about the specified group of users.
HListGroup (Function)
Returns the list of groups of users defined for a connection.
HListUser (Function)
Returns the list of users defined for a connection.
HListStoredElement (Function)
Returns the list of elements stored on an HFSQL server (sets of procedures, stored procedures or queries).
HFSQL in network mode on a server running Windows NT4, 2000, XP or 2003
The access speed to the data in network depends on several parameters (see the section......
HListServerTrigger (Function)
Lists the different triggers available on a connection or on one of the connection files.
<Connection variable>.ServerMaintenance (Function)
Checks and optimizes the system tables of an HFSQL server.
Secure (Property)
The Secure property is used to configure the security level of data file encryption.
HResetClient (Function)
Initializes the structure for managing the Client computers (HClient structure).
<Connection variable>.TransactionList (Function)
Returns the list of current or interrupted transactions on the server for the specified connection.
<Connection>.InfoLock (Function)
Returns information about the lock set on a data file, on one or all the records in a data file.
<Connection variable>.RestoreBackup (Function)
Used to restore: an immediate backup (performed by HBackup or via the HFSQL Control Center), a scheduled backup (described by HAddScheduledBackup or via the HFSQL Control Center....
HRestoreBackup (Function)
Used to restore: an immediate backup (performed by HBackup or via the HFSQL Control Center), a scheduled backup (described by HAddScheduledBackup or via the HFSQL Control Center....
<Connection variable>.DeleteGroup (Function)
Deletes (from the server) a group of users associated with a connection.
<Connection variable>.CancelBackup (Function)
Cancels a current backup.