<Connection variable>.ActivateServerTrigger (Function) Re-enables a server trigger that was disabled by HDeactivateServerTrigger. <Connection variable>.AddGroup (Function) Adds a group of users. <Connection variable>.AddLink (Function) Adds an integrity rule between two files on the server. <Connection variable>.AddScheduledBackup (Function) Adds a scheduling for full backup (with or without differential backup) on the server defined by the connection. <Connection variable>.AddScheduledOptimization (Function) Adds an optimization task of HFSQL Client/Server tables. <Connection variable>.AddScheduling (Function) Adds a new scheduled item to an HFSQL server: scheduled task (stored procedure), backup, optimization or refresh of a materialized view. <Connection variable>.AddTask (Function) Adds a scheduled task on the server defined by the connection. <Connection variable>.AddUser (Function) Adds a user to a database. <Connection variable>.Backup (Function) Backs up the contents of an HFSQL server: all server databases, one or more databases, one or more tables. <Connection variable>.CancelBackup (Function) Cancels a current backup. <Connection variable>.CheckServerUpdate (Function) Checks for the latest version of the HFSQL server that can be automatically updated. <Connection variable>.ConnectionQuality (Function) Returns the quality level of the connection: the higher the level is, the faster the connection is. <Connection variable>.CopyFile (Function) Copies an HFSQL table (.fic, .ndx, .ftx, .sdx and .mmo files, if any): from the HFSQL server to the server (to perform a backup for example). from the HFSQL server to the client (to perform a local backup for example). from the client to the HFSQL server (to update the tables for example). from an HFSQL server to antoher HFSQL server. <Connection variable>.DeactivateServerTrigger (Function) Disables an HFSQL Client/Server server trigger on a server. <Connection variable>.DeleteBackup (Function) Deletes a backup previously created with HBackup. <Connection variable>.DeleteDatabase (Function) Deletes a database located on an HFSQL server. <Connection variable>.DeleteDirectory (Function) Deletes a directory from an HFSQL Client/Server database. <Connection variable>.DeleteFile (Function) Deletes HFSQL tables (.fic, .ndx, .ftx, .sdx and .mmo files, if any) from the server. <Connection variable>.DeleteGroup (Function) Deletes (from the server) a group of users associated with a connection. <Connection variable>.DeleteLink (Function) Deletes an integrity rule between two tables on the server. <Connection variable>.DeleteParameter (Function) Deletes a parameter previously saved by HSaveParameter. <Connection variable>.DeleteQuery (Function) Deletes a query (used by stored procedures) from an HFSQL server. <Connection variable>.DeleteScheduledBackup (Function) Deletes a scheduled backup from an HFSQL Client/Server server. <Connection variable>.DeleteScheduledOptimization (Function) Deletes a scheduled optimization task from HFSQL Client/Server tables. <Connection variable>.DeleteScheduling (Function) Delete a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. <Connection variable>.DeleteSchedulingHistory (Function) Deletes the executions of a scheduled operation on an HFSQL server. This operation can be a scheduled task (stored procedure), backup, optimization or a materialized view refresh. <Connection variable>.DeleteServerTrigger (Function) Deletes a server trigger. <Connection variable>.DeleteSet (Function) Deletes a set of stored procedures from an HFSQL server. <Connection variable>.DeleteTask (Function) Deletes a scheduled task from an HFSQL Client/Server server. <Connection variable>.DeleteUser (Function) Deletes a user associated with a connection to the HFSQL server. <Connection variable>.DescribeServerTrigger (Function) Adds or modifies a server trigger. <Connection variable>.DisconnectClient (Function) Displays a message on the Client computer(s) and disconnects the application. <Connection variable>.DropView (Function) Deletes a materialized view from the HFSQL server. <Connection variable>.DuplicateDatabase (Function) Duplicates the database associated with a connection on an HFSQL server. <Connection variable>.EndNoDatabaseAccess (Function) Re-allows the access (which means the connection) to one or more databases accessible via a connection. <Connection variable>.ExecuteProcedure (Function) Runs a stored procedure. <Connection variable>.ExecuteScheduledBackup (Function) Forces the execution of a scheduled backup. <Connection variable>.ExecuteScheduling (Function) Immediately executes a scheduled item regardless of its scheduling: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. <Connection variable>.InfoBackup (Function) Returns information about one or more backups performed on an HFSQL Client/Server server. <Connection variable>.InfoDatabaseProperty (Function) Used to find out the properties of a database on an HFSQL server. <Connection variable>.InfoDatabaseRights (Function) Gets the rights granted to a user or group on a database. <Connection variable>.InfoFileProperty (Function) Allows you to find out the properties of a table located in an HFSQL server. <Connection variable>.InfoFileRights (Function) Gets the rights granted to a user or group on an HFSQL Client/Server table. <Connection variable>.InfoGroup (Function) Returns information about the specified group of users. <Connection variable>.InfoItemRights (Function) Gets the rights granted to a user or group on an item. <Connection variable>.InfoLock (Function) Returns information about the lock set on a table, on one or all the records in a table. <Connection variable>.InfoServer (Function) Returns the specified information about the server. <Connection variable>.InfoServerProperty (Function) Allows you to find out the properties of an HFSQL server. <Connection variable>.InfoServerRights (Function) Gets the rights granted to a user or group of users on a server. <Connection variable>.InfoTask (Function) Returns the characteristics of a scheduled task in a hScheduledTask variable]. <Connection variable>.InfoUser (Function) Updates the variables for user management with the information regarding the specified user. <Connection variable>.InfoView (Function) Returns information about a materialized view. <Connection variable>.InfoViewRights (Function) Gets the rights granted to a user or group on an SQL view or on a materialized view. <Connection variable>.ListDatabase (Function) Lists the Client/Server databases associated with a connection. <Connection variable>.ListGroup (Function) Returns the list of groups of users defined for a connection. <Connection variable>.ListParameter (Function) Returns the list of parameters saved from the stored procedures on the server. <Connection variable>.ListScheduledBackup (Function) Lists the full and differential backups that have been scheduled on HFSQL Client/Server. <Connection variable>.ListScheduledOptimization (Function) Lists the scheduled optimization tasks of HFSQL Client/Server tables for a connection. <Connection variable>.ListScheduling (Function) Lists scheduled elements defined on an HFSQL server: scheduled tasks (stored procedure), backup, optimization, refresh of a materialized view. <Connection variable>.ListSchedulingHistory (Function) Lists the executions of a scheduled operation on an HFSQL server. This operation can be a scheduled task (stored procedure), backup, optimization or a materialized view refresh. <Connection variable>.ListStoredElement (Function) Returns the list of elements stored on an HFSQL server (sets of procedures, stored procedures or queries). <Connection variable>.ListTask (Function) Lists the scheduled tasks of an HFSQL Client/Server server for a given connection. <Connection variable>.ListUser (Function) Returns the list of users defined for a connection. <Connection variable>.ListWatchedFiles (Function) Returns a list of tables monitored by the HWatch function. <Connection variable>.LoadParameter (Function) Reads a parameter that was saved from a stored procedure by HSaveParameter. <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. <Connection variable>.ManageTask (Function) Enables or disables a scheduled task on an HFSQL Client/Server server. <Connection variable>.ModifyDatabaseProperty (Function) Modifies the properties of a database located on an HFSQL server. <Connection variable>.ModifyDatabaseRights (Function) Sets the rights granted to a user or group for an HFSQL Client/Server database. <Connection variable>.ModifyFileProperty (Function) Modifies the properties of an HFSQL table located on a server. <Connection variable>.ModifyFileRights (Function) Sets the rights granted to a user or group on an HFSQL Client/Server table. <Connection variable>.ModifyGroup (Function) Modifies the group information according to the elements found in the corresponding variables for group management. <Connection variable>.ModifyItemRights (Function) Modifies the rights granted to a user or group on an item of an HFSQL Client/Server table. <Connection variable>.ModifyScheduledBackup (Function) Modifies a backup scheduling. <Connection variable>.ModifyScheduledOptimization (Function) Modifies a scheduled optimization task on the HFSQL server defined by the connection. <Connection variable>.ModifyScheduling (Function) Modify a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. <Connection variable>.ModifyServerProperty (Function) Modifies the properties of an HFSQL server. <Connection variable>.ModifyServerRights (Function) Sets the rights granted to a user or group on an HFSQL server. <Connection variable>.ModifyTask (Function) Modifies a scheduled task on the HFSQL server defined by the connection. <Connection variable>.ModifyUser (Function) Modifies the information about a user according to the elements found in the corresponding variables for user management. <Connection variable>.ModifyViewRights (Function) Sets the rights granted to a user or group on an SQL view or on a materialized view. <Connection variable>.NoDatabaseAccess (Function) Denies all new connections to a database or to all databases. <Connection variable>.NotifAddCCRecipient (Function) Adds recipients for the notifications sent via the Control Centers (WDBal messaging tool). <Connection variable>.NotifAddEmailRecipient (Function) Adds recipients for the notifications sent by email. <Connection variable>.NotifConfigure (Function) Specifies and configures the server used to send notifications by the HFSQL server. <Connection variable>.NotifDeleteCCRecipient (Function) Deletes the recipients of a notification sent via the Control Centers (WDBal messaging tool). <Connection variable>.NotifDeleteEmailRecipient (Function) Deletes the recipients of an email notification. <Connection variable>.NotifListCCRecipient (Function) Returns the list of recipients of a notification sent via the Control Centers (WDBal messaging tool). <Connection variable>.NotifListEmailRecipient (Function) Returns the list of recipients for a notification by email. <Connection variable>.OperationInProgress (Function) Returns the list of automatic operations in progress on an HFSQL server. <Connection variable>.Priority (Function) Finds out and modifies the priority of the calling application. <Connection variable>.PriorityClient (Function) Modifies the priority of a client application. <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. <Connection variable>.RetrieveBackup (Function) Retrieves locally the content of a compressed backup (in ZIP format) performed on an HFSQL server. <Connection variable>.RetrieveLog (Function) Creates a text file containing the server logs between two given dates. <Connection variable>.SaveParameter (Function) Saves a persistent value on the HFSQL server. <Connection variable>.SendMessageToClient (Function) Displays a message on the client computers. <Connection variable>.ServerMaintenance (Function) Checks and optimizes the system tables of an HFSQL server. <Connection variable>.SetServer (Function) Used to find out and modify some settings of HFSQL Client/Server server. <Connection variable>.SimulateNetwork (Function) Simulates the operating mode of HFSQL Client/Server on an ADSL or 3G network. <Connection variable>.StartServerUpdate (Function) Used to immediately start the automatic server update. <Connection variable>.StopServer (Function) Stops an HFSQL server. <Connection variable>.TransactionIsolation (Function) Configures the isolation level of transactions for a connection to an HFSQL server. <Connection variable>.TransactionList (Function) Returns the list of current or interrupted transactions on the server for the specified connection. <Connection variable>.TransactionRollbackToSavepoint (Function) Rolls the transaction back to the savepoint. <Connection variable>.TransactionSavepoint (Function) Declares a transaction savepoint. <Connection variable>.UpdateQuery (Function) Creates or updates a query on an HFSQL server. <Connection variable>.UpdateSet (Function) Creates or updates a set of procedures on an HFSQL server. <Connection variable>.UpdateView (Function) Creates or updates the description of an SQL view or materialized view from the analysis to an HFSQL server. <Connexion HFSQL>AsynchronousMemoCheck (Function) Checks the structural integrity of memos in an HFSQL Client/Server table. This new function is available from WINDEV Suite SaaS 2025 - Update 2. <Connexion HFSQL>CheckAsynchronousIndex (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 new function is available from WINDEV Suite SaaS 2025 - Update 2. <Connexion HFSQL>ListHistoryReindexing (Function) Lists the operations performed on current tables, over the last 24 hours, or on the last 1000 tables. These operations include reindexing, recalculation of statistics, memo verification, index verification, etc. This new function is available from WINDEV Suite SaaS 2025 - Update 2. <Connexion HFSQL>StatCalculAsynchronous (Function) Gets various statistics on the keys of an HFSQL Client/Server table. This new function is available from WINDEV Suite SaaS 2025 - Update 2. <Source>.ChangePassword (Function) Changes the password of an HFSQL Classic or HFSQL Client/Server table. <Source>.InfoLock (Function) Returns information about the lock set on a table, on one or all the records in a table. <Source>.UpdateLink (Function) Updates on the server all the links of an HFSQL Client/Server table. Warning: This function is available only from WINDEV Suite SaaS 2025 Update 2. For more details, see Using new features exclusive to WINDEV Suite SaaS 2025. <Source>.Watch (Function) Trigger monitoring of write actions (add, modify or delete) performed on a table present on an HFSQL server. In case of modification, a specific procedure can be triggered. <Source>.WatchStop (Function) Stops watching a table on an HFSQL server. <Variable Connexion>ExecuteAsynchronousProcedure (Function) Executes a stored procedure in asynchronous mode. This new function is available from WINDEV Suite SaaS 2025 Update 2. HAddGroup (Function) Adds a group of users. HAddLink (Function) Adds an integrity rule between two tables on the server. HAddScheduledBackup (Function) Adds a scheduling for full backup (with or without differential backup) on the server defined by the connection. HAddScheduledOptimization (Function) Adds an optimization task of HFSQL Client/Server tables. HAddScheduling (Function) Adds a new scheduled item to an HFSQL server: scheduled task (stored procedure), backup, optimization or refresh of a materialized view. HAddTask (Function) Adds a scheduled task on the server defined by the connection. HAddUser (Function) Adds a user to a database. HBackup (Function) Backs up the contents of an HFSQL server: all server databases, one or more databases, one or more tables. HCancelBackup (Function) Cancels a current backup. HChangePassword (Function) Changes the password of an HFSQL Classic or HFSQL Client/Server table. 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 new function is available from WINDEV Suite SaaS 2025 - Update 2. HCheckMemoAsynchronous (Function) Checks the structural integrity of memos in an HFSQL Client/Server table. This new function is available from WINDEV Suite SaaS 2025 - Update 2. HCheckServerUpdate (Function) Checks for the latest version of the HFSQL server that can be automatically updated. HClearSchedulingHistory (Function) Clears the execution history of scheduled operations on an HFSQL server. HClearWorkingDir (Function) Clears and destroys the temporary directory previously created when HServerWorkingDir was executed. HConnectionQuality (Function) Returns the quality level of the connection: the higher the level is, the faster the connection is. HCopyFile (Example) Usage example of the HCopyFile function HCopyFile (Function) Copies an HFSQL table (.fic, .ndx, .ftx, .sdx and .mmo files, if any): from the HFSQL server to the server (to perform a backup for example). from the HFSQL server to the client (to perform a local backup for example). from the client to the HFSQL server (to update the tables for example). from an HFSQL server to antoher HFSQL server. HCS.FrameSize (Variable) The HCS.FrameSize variable is used to resize the outgoing data frame. HCS.Timeout (Variable) The HCS.ResponseTime variable is used to modify the connection time: for the connections established by HOpenConnection. for the automatic connection openings. HDeleteBackup (Function) Deletes a backup previously created with HBackup. HDeleteDatabase (Function) Deletes a database located on an HFSQL server. HDeleteDirectory (Function) Deletes a directory from an HFSQL Client/Server database. HDeleteFile (Function) Deletes HFSQL tables (.fic, .ndx, .ftx, .sdx and .mmo files, if any) from the server. HDeleteGroup (Function) Deletes (from the server) a group of users associated with a connection. HDeleteLink (Function) Deletes an integrity rule between two tables on the server. HDeleteParameter (Function) Deletes a parameter previously saved by HSaveParameter. HDeleteQuery (Function) Deletes a query (used by stored procedures) from an HFSQL server. HDeleteScheduledBackup (Function) Deletes a scheduled backup from an HFSQL Client/Server server. HDeleteScheduledOptimization (Function) Deletes a scheduled optimization task from HFSQL Client/Server tables. HDeleteScheduling (Function) Delete a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. HDeleteSchedulingHistory (Function) Deletes the executions of a scheduled operation on an HFSQL server. This operation can be a scheduled task (stored procedure), backup, optimization or a materialized view refresh. HDeleteSet (Function) Deletes a set of stored procedures from an HFSQL server. HDeleteTask (Function) Deletes a scheduled task from an HFSQL Client/Server server. HDeleteUser (Function) Deletes a user associated with a connection to the HFSQL server. HDisconnectClient (Function) Displays a message on the Client computer(s) and disconnects the application. HDropView (Function) Deletes a materialized view from the HFSQL server. HDuplicateDatabase (Function) Duplicates the database associated with a connection on an HFSQL server. HEndNoDatabaseAccess (Function) Re-allows the access (which means the connection) to one or more databases accessible via a connection. HExecuteAsynchronousProcedure (Function) Executes a stored procedure in asynchronous mode. This new function is available from WINDEV Suite SaaS 2025 - Update 2. HExecuteProcedure (Function) Runs a stored procedure. HExecuteScheduledBackup (Function) Forces the execution of a scheduled backup. HExecuteScheduling (Function) Immediately executes a scheduled item regardless of its scheduling: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. HFSQL Client/Server functions Several HFSQL functions are used to manage the HFSQL Client/Server data... HFSQL Client/Server functions (prefix syntax) Several HFSQL functions are used to manage the HFSQL Client/Server data... HFSQL Client/Server: Scheduled optimization Scheduled optimization is a mechanism for automatically optimizing your database... HInfoBackup (Function) Returns information about one or more backups performed on an HFSQL Client/Server server. HInfoDatabaseProperty (Function) Used to find out the properties of a database on an HFSQL server. HInfoDatabaseRights (Example) Usage example of HInfoDatabaseRights HInfoDatabaseRights (Function) Gets the rights granted to a user or group on a database. HInfoFileProperty (Function) Allows you to find out the properties of a table located in an HFSQL server. HInfoFileRights (Example) Usage example of the HInfoFileRights function HInfoFileRights (Function) Gets the rights granted to a user or group on an HFSQL Client/Server table. HInfoGroup (Function) Returns information about the specified group of users. HInfoItemRights (Function) Gets the rights granted to a user or group on an item. HInfoLock (Function) Returns information about the lock set on a table, on one or all the records in a table. HInfoLog (Function) Returns information about the server logs. HInfoServer (Function) Returns the specified information about the server. HInfoServerProperty (Function) Allows you to find out the properties of an HFSQL server. HInfoServerRights (Function) Gets the rights granted to a user or group of users on a server. HInfoTask (Function) Returns the characteristics of a scheduled task in a hScheduledTask variable]. HInfoUser (Function) Updates the variables for user management with the information regarding the specified user. HInfoView (Function) Returns information about a materialized view. HInfoViewRights (Function) Gets the rights granted to a user or group on an SQL view or on a materialized view. HListConnectedUser (Function) Lists users currently connected to one or more tables handled by a Client/Server connection. HListDatabase (Function) Lists the Client/Server databases associated with a connection. HListGroup (Function) Returns the list of groups of users defined for a connection. HListHistoryReindexing (Function) Lists the operations performed on current tables, over the last 24 hours, or on the last 1000 tables. These operations include reindexing, recalculation of statistics, memo verification, index verification, etc. This new function is available from WINDEV Suite SaaS 2025 - Update 2. HListParameter (Function) Returns the list of parameters saved from the stored procedures on the server. HListScheduledBackup (Function) Lists the full and differential backups that have been scheduled on HFSQL Client/Server. HListScheduledOptimization (Function) Lists the scheduled optimization tasks of HFSQL Client/Server tables for a connection. HListScheduling (Function) Lists scheduled elements defined on an HFSQL server: scheduled tasks (stored procedure), backup, optimization, refresh of a materialized view. HListSchedulingHistory (Function) Lists the executions of a scheduled job on an HFSQL server. This job can be a scheduled task (stored procedure), backup, optimization or a materialized view refresh. HListServer (Function) Lists the HFSQL servers installed on a computer. HListStoredElement (Function) Returns the list of elements stored on an HFSQL server (sets of procedures, stored procedures or queries). HListTask (Function) Lists the scheduled tasks of an HFSQL Client/Server server for a given connection. HListUser (Function) Returns the list of users defined for a connection. HListWatchedFiles (Function) Returns a list of tables monitored by the HWatch function. HLoadParameter (Function) Reads a parameter that was saved from a stored procedure by HSaveParameter. HManageServerUpdate (Function) Allows you to manage the automatic update of HFSQL Client/Server servers and to define how often to check for updates. HManageTask (Function) Enables or disables a scheduled task on an HFSQL Client/Server server. HModifyDatabaseProperty (Function) Modifies the properties of a database located on an HFSQL server. HModifyDatabaseRights (Function) Sets the rights granted to a user or group for an HFSQL Client/Server database. HModifyFileProperty (Function) Modifies the properties of an HFSQL table located on a server. HModifyFileRights (Function) Sets the rights granted to a user or group on an HFSQL Client/Server table. HModifyGroup (Function) Modifies the group information according to the elements found in the corresponding variables for group management. HModifyItemRights (Function) Modifies the rights granted to a user or group on an item of an HFSQL Client/Server table. HModifyScheduledBackup (Function) Modifies a backup scheduling. HModifyScheduledOptimization (Function) Modifies a scheduled optimization task on the HFSQL server defined by the connection. HModifyScheduling (Function) Modify a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. HModifyServerProperty (Function) Modifies the properties of an HFSQL server. HModifyServerRights (Function) Sets the rights granted to a user or group on an HFSQL server. HModifyTask (Function) Modifies a scheduled task on the HFSQL server defined by the connection. HModifyUser (Function) Modifies the information about a user according to the elements found in the corresponding variables for user management. HModifyViewRights (Function) Sets the rights granted to a user or group on an SQL view or on a materialized view. HNoDatabaseAccess (Function) Denies all new connections to a database or to all databases. HNotifAddCCRecipient (Function) Adds recipients for the notifications sent via the Control Centers (WDBal messaging tool). HNotifAddEmailRecipient (Function) Adds recipients for the notifications sent by email. HNotifConfigure (Function) Specifies and configures the server used to send notifications by the HFSQL server. HNotifDeleteCCRecipient (Function) Deletes the recipients of a notification sent via the Control Centers (WDBal messaging tool). HNotifDeleteEmailRecipient (Function) Deletes the recipients of an email notification. HNotifListCCRecipient (Function) Returns the list of recipients of a notification sent via the Control Centers (WDBal messaging tool). HNotifListEmailRecipient (Function) Returns the list of recipients for a notification by email. HOnServerCall (Function) Customizes the management of message display on the client computer and the management of disconnection from a client computer. HOperationInProgress (Function) Returns the list of automatic operations in progress on an HFSQL server. HPriority (Function) Finds out and modifies the priority of the calling application. HPriorityClient (Function) Modifies the priority of a client application. HReconnect (Function) Performs a reconnection to the server for all the interrupted connections. The uninterrupted connections are not modified. HResetClient (Function) Initializes the structure for managing the Client computers (HClient structure). HResetGroup (Function) Initializes the structure for group management (HGroup) with the default values. HResetUser (Function) Initializes the structure for user management (HUser) with the default values. 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. HRetrieveBackup (Function) Retrieves locally the content of a compressed backup (in ZIP format) performed on an HFSQL server. HRetrieveLog (Function) Creates a text file containing the server logs between two given dates. HSaveParameter (Function) Saves a persistent value on the HFSQL server. HSendMessageToClient (Function) Displays a message on the client computers. HServerMaintenance (Function) Checks and optimizes the system tables of an HFSQL server. hServerOperation (Variable type) The hServerOperation type is used to get the characteristics of an operation performed on an HFSQL server. HServerStatus (Function) Allows you to find out the status of an HFSQL server (this function uses the MantaManager service). HServerWorkingDir (Function) Returns the path of a temporary directory on the HFSQL server. HSetCache (Function) Used to configure the management of caches in the HFSQL Client/Server engine. HSetServer (Function) Used to find out and modify some settings of HFSQL Client/Server server. HSimulateNetwork (Function) Simulates the operating mode of HFSQL Client/Server on an ADSL or 3G network. HStartServer (Function) Allows you to start an HFSQL server (this function uses the MantaManager service). HStartServerUpdate (Function) Used to immediately start the automatic server update. HStatCalculateAsynchronous (Function) Gets various statistics on the keys of an HFSQL Client/Server table. This new function is available from WINDEV Suite SaaS 2025 - Update 2. HStopServer (Function) Stops an HFSQL server. HSuggestKey (Function) Returns a list of keys to add to tables to improve query performance. HSuggestKeyEnd (Function) Finishes collecting information on executed queries. HSuggestKeyStart (Function) Starts collecting information on executed queries. HTransactionRollbackToSavepoint (Function) Rolls the transaction back to the savepoint. HTransactionSavepoint (Function) Declares a transaction savepoint. HUpdateLink (Function) Updates on the server all the links of an HFSQL Client/Server table. Warning: This function is available only from WINDEV Suite SaaS 2025 Update 2. For more details, see Using new features exclusive to WINDEV Suite SaaS 2025. HUpdateQuery (Function) Creates or updates a query on an HFSQL server. HUpdateSet (Function) Creates or updates a set of procedures on an HFSQL server. HUpdateView (Function) Creates or updates the description of an SQL view or materialized view from the database schema to an HFSQL server. HWatch (Function) Trigger monitoring of write actions (add, modify or delete) performed on a table present on an HFSQL server. In case of modification, a specific procedure can be triggered. HWatchStop (Function) Stops watching a table on an HFSQL server. WLanguage procedure 5 documents