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.
<Source>.Password (Function)
Defines the password used to create or open a data file.
HPass (Function)
Defines the password used to create or open a data file.
HFSQL management functions (prefix syntax)
List of functions for HFSQL management...
HTransactionInterrupted (Function)
Used to find out whether a transaction was interrupted (the transaction was neither validated nor canceled).
HFSQL management functions
List of functions for HFSQL management...
<Source>.ChangeDir (Function)
Changes the path to a data file (i.e. directory in which the file will be handled).
<Source>.TransactionFree (Function)
Transforms all "in transaction" records into "Normal" records if they do not belong to an ongoing transaction.
<Source>.SetTransaction (Function)
Enables or disables the management of transactions for one or more files.
<Source>.ChangeConnection (Function)
Dynamically changes the connection associated with a data file.
HSetTransaction (Function)
Enables or disables the management of transactions for one or more files.
HChangeConnection (Function)
Dynamically changes the connection associated with a data file.
HChangeDir (Function)
Changes the path to a data file (i.e. directory in which the file will be handled).
<Connection variable>.TransactionStart (Function)
Starts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file.
HTransactionFree (Function)
Transforms all the records "in transaction" into "Normal" records if these records do not belong to a transaction currently in progress.
<Connection variable>.Transaction (Function)
Starts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file.
<Connection variable>.TransactionCancel (Function)
If a transaction is in progress, cancels all the operations performed on the data files in transaction since the start of transaction.
<Connection variable>.TransactionEnd (Function)
Validates the current transaction: the modifications performed on the data file since the start of transaction (HTransactionStart) are validated. the transaction file is deleted (if the transaction is the last transaction in progress for a network application) the records locked in read-only by the transaction are unlocked....
HTransactionStart (Function)
Starts a transaction on the data files (HFSQL or accessed via a Native Connector) and creates the transaction file.
HTransaction (Function)
Starts a transaction on the data files (HFSQL or accessed via a Native Connector) and creates the transaction file.
User Groupware: Configuring the site
Once the User Groupware is configured, the configuration of users and accesses is performed at runtime, by connecting with a "supervisor" account......
<Connection variable>.NotifConfigure (Function)
Specifies and configures the server used to send notifications by the HFSQL server.
<Connection variable>.NotifListCCRecipient (Function)
Returns the list of recipients of a notification sent via the Control Centers (WDBal messaging tool).
HTransactionCancel (Function)
If a transaction is in progress, cancels all the operations performed on the data files in transaction since the start of transaction.
HTransactionEnd (Function)
Validates the current transaction: the modifications performed on the data file since the start of transaction (HTransactionStart) are validated. the transaction file is deleted (if the transaction is the last transaction in progress for a network application) the records locked in read-only by the transaction are unlocked....
<Connection variable>.NotifAddCCRecipient (Function)
Adds recipients for the notifications sent via the Control Centers (WDBal messaging tool).