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>.DeleteUser (Function)
Deletes a user associated with a connection to the HFSQL server.
Transactions in SQL
Starting with version 21, you can manage transactions in SQL code......
HListServer (Function)
Lists the HFSQL servers installed on a computer.
HDeleteGroup (Function)
Deletes (from the server) a group of users associated with a connection.
HDeleteUser (Function)
Deletes a user associated with a connection to the HFSQL server.
HCancelBackup (Function)
Cancels a current backup.
HServerMaintenance (Function)
Checks and optimizes the system tables of an HFSQL server.
<Connection variable>.AddTask (Function)
Adds a scheduled task on the server defined by the connection.
<Connection variable>.ModifyScheduledBackup (Function)
Modifies a backup scheduling.
<Connection variable>.DeleteBackup (Function)
Deletes a backup previously created with HBackup.
HAddTask (Function)
Adds a scheduled task on the server defined by the connection.
HModifyScheduledBackup (Function)
Modifies a backup scheduling.
HDeleteBackup (Function)
Deletes a backup previously created with HBackup.
Debugging a connection to an HFSQL server
The stored procedures and the triggers are debugged from the environment, with real execution on the server......
<Connection variable>.Backup (Function)
Makes a backup copy of the content of an HFSQL server: all databases on the server, one or more databases, one or more data files.
<Connection variable>.StopServer (Function)
Stops an HFSQL server.
HSuggestKeyStart (Function)
Starts collecting information on executed queries.
HSuggestKeyEnd (Function)
Finishes collecting information on executed queries.
<Source>.Track (Function)
Starts tracking write actions (addition, modification or deletion) performed on a file found in an HFSQL server.
<Source>.TrackStop (Function)
Stops tracking a data file on an HFSQL server.
HInfoLog (Function)
Returns information about the server logs.
<Connection variable>.DeleteServerTrigger (Function)
Deletes a server trigger.
<Connection variable>.DescribeServerTrigger (Function)
Adds or modifies a server trigger.
<Connection variable>.EndNoDatabaseAccess (Function)
Re-allows the access (which means the connection) to one or more databases accessible via a connection.
<Connection variable>.InfoViewRights (Function)
Allows you to find out the rights granted to a user or to a group on an SQL view or on a materialized view.