| |
| HActivateServerTrigger | Re-enables a server trigger that was disabled by HDeactivateServerTrigger. |
| HAddGroup | Adds a group of users. |
| HAddLink | Adds an integrity rule between two data files on the server. |
| HAddScheduledBackup | Adds a scheduling for full backup (with or without differential backup) on the server defined by the connection. |
| HAddScheduledOptimization | Adds an optimization task of HFSQL Client/Server data files. |
| HAddScheduling | Adds a new scheduled item to an HFSQL server: scheduled task (stored procedure), backup, optimization or refresh of a materialized view. |
| HAddTask | Adds a scheduled task on the server defined by the connection. |
| HAddUser | Adds a user to a database. |
| HBackup | Backs up the contents of an HFSQL server: all server databases, one or more databases, one or more data files. |
| HCancelBackup | Cancels a current backup. |
| HChangePassword | Changes the password of an HFSQL Classic or HFSQL Client/Server data file. |
| Checks that the data contained in the index file (.NDX file) correctly references the data contained in the HFSQL Client/Server data file (.FIC file). This new function is available from WINDEV Suite SaaS 2025 - Update 2. |
| Checks the structural integrity of memos in an HFSQL Client/Server data file. This new function is available from WINDEV Suite SaaS 2025 - Update 2. |
| HCheckServerUpdate | Checks for the latest version of the HFSQL server that can be automatically updated. |
| Clears the execution history of scheduled jobs on an HFSQL server. |
| HClearWorkingDir | Clears and destroys the temporary directory previously created when HServerWorkingDir was executed. |
| HConnectionQuality | Returns the quality level of the connection: the higher the level is, the faster the connection is. |
| HCopyFile | Copies an HFSQL data file (.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 data files for example).
- from an HFSQL server to antoher HFSQL server.
|
| HCreateServerTrigger | Adds or modifies a server trigger on the HFSQL server. |
| HCS.FrameSize | The HCS.FrameSize variable is used to resize the outgoing data frame. |
| HDeactivateServerTrigger | Disables an HFSQL Client/Server server trigger on a server. |
| HDeleteBackup | Deletes a backup previously created with HBackup. |
| HDeleteDatabase | Deletes a database located on an HFSQL server. |
| HDeleteDirectory | Deletes a directory from an HFSQL Client/Server database. |
| HDeleteFile | Deletes HFSQL data files (.fic, .ndx, .ftx, .sdx and .mmo files, if any) from the server. |
| HDeleteGroup | Deletes (from the server) a group of users associated with a connection. |
| HDeleteLink | Deletes an integrity rule between two data files on the server. |
| HDeleteParameter | Deletes a parameter previously saved by HSaveParameter. |
| HDeleteQuery | Deletes a query (used by stored procedures) from an HFSQL server. |
| HDeleteScheduledBackup | Deletes a scheduled backup from an HFSQL Client/Server server. |
| HDeleteScheduledOptimization | Deletes a scheduled optimization task from HFSQL Client/Server data files. |
| HDeleteScheduling | Delete a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. |
| Deletes 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. |
| HDeleteServerTrigger | Deletes a server trigger. |
| HDeleteSet | Deletes a set of stored procedures from an HFSQL server. |
| HDeleteTask | Deletes a scheduled task from an HFSQL Client/Server server. |
| HDeleteUser | Deletes a user associated with a connection to the HFSQL server. |
| HDescribeServerTrigger | Adds or modifies a server trigger. |
| HDisconnectClient | Displays a message on the Client computer(s) and disconnects the application. |
| HDropView | Deletes a materialized view from the HFSQL server. |
| HDuplicateDatabase | Duplicates the database associated with a connection on an HFSQL server. |
| HEndNoDatabaseAccess | Re-allows the access (which means the connection) to one or more databases accessible via a connection. |
| Executes a stored procedure in asynchronous mode. This new function is available from WINDEV Suite SaaS 2025 - Update 2. |
| HExecuteProcedure | Runs a stored procedure. |
| HExecuteScheduledBackup | Forces the execution of a scheduled backup. |
| HExecuteScheduling | Immediately executes a scheduled item regardless of its scheduling: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. |
| HInfoBackup | Returns information about one or more backups performed on an HFSQL Client/Server server. |
| HInfoDatabaseProperty | Used to find out the properties of a database on an HFSQL server. |
| HInfoDatabaseRights | Gets the rights granted to a user or group on a database. |
| HInfoFileProperty | Allows you to find out the properties of a data file located in an HFSQL server. |
| HInfoFileRights | Gets the rights granted to a user or group on an HFSQL Client/Server data file. |
| HInfoGroup | Returns information about the specified group of users. |
| HInfoItemRights | Gets the rights granted to a user or group on an item. |
| HInfoLock | Returns information about the lock set on a data file, on one or all the records in a data file. |
| HInfoLog | Returns information about the server logs. |
| HInfoServer | Returns the specified information about the server. |
| HInfoServerProperty | Allows you to find out the properties of an HFSQL server. |
| HInfoServerRights | Gets the rights granted to a user or group of users on a server. |
| HInfoTask | Returns the characteristics of a scheduled task in a hScheduledTask variable]. |
| HInfoUser | Updates the variables for user management with the information regarding the specified user. |
| HInfoView | Returns information about a materialized view. |
| HInfoViewRights | Gets the rights granted to a user or group on an SQL view or on a materialized view. |
| HListConnectedUser | Lists users currently connected to one or more data files handled by a Client/Server connection. |
| HListDatabase | Lists the Client/Server databases associated with a connection. |
| HListGroup | Returns the list of groups of users defined for a connection. |
| Lists the operations performed on current data files, over the last 24 hours, or on the last 1000 files. 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 | Returns the list of parameters saved from the stored procedures on the server. |
| HListScheduledBackup | Lists the full and differential backups that have been scheduled on HFSQL Client/Server. |
| HListScheduledOptimization | Lists the scheduled optimization tasks of HFSQL Client/Server data files for a connection. |
| HListScheduling | Lists scheduled elements defined on an HFSQL server: scheduled tasks (stored procedure), backup, optimization, refresh of a materialized view. |
| 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 | Lists the HFSQL servers installed on a computer. |
| HListServerTrigger | Lists the different triggers available on a connection or on one of the connection files. |
| HListStoredElement | Returns the list of elements stored on an HFSQL server (sets of procedures, stored procedures or queries). |
| HListTask | Lists the scheduled tasks of an HFSQL Client/Server server for a given connection. |
| HListUser | Returns the list of users defined for a connection. |
| HListWatchedFiles | Returns a list of data files monitored by the HWatch function. |
| HLoadParameter | Reads a parameter that was saved from a stored procedure by HSaveParameter. |
| HManageServerUpdate | Allows you to manage the automatic update of HFSQL Client/Server servers and to define how often to check for updates. |
| HManageTask | Enables or disables a scheduled task on an HFSQL Client/Server server. |
| HModifyDatabaseProperty | Modifies the properties of a database located on an HFSQL server. |
| HModifyDatabaseRights | Sets the rights granted to a user or group for an HFSQL Client/Server database. |
| HModifyFileProperty | Modifies the properties of an HFSQL data file located on a server. |
| HModifyFileRights | Sets the rights granted to a user or group on an HFSQL Client/Server data file. |
| HModifyGroup | Modifies the group information according to the elements found in the corresponding variables for group management. |
| HModifyItemRights | Modifies the rights granted to a user or group on an item of an HFSQL Client/Server data file. |
| HModifyScheduledBackup | Modifies a backup scheduling. |
| HModifyScheduledOptimization | Modifies a scheduled optimization task on the HFSQL server defined by the connection. |
| HModifyScheduling | Modify a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. |
| HModifyServerProperty | Modifies the properties of an HFSQL server. |
| HModifyServerRights | Sets the rights granted to a user or group on an HFSQL server. |
| HModifyTask | Modifies a scheduled task on the HFSQL server defined by the connection. |
| HModifyUser | Modifies the information about a user according to the elements found in the corresponding variables for user management. |
| HModifyViewRights | Sets the rights granted to a user or group on an SQL view or on a materialized view. |
| HNoDatabaseAccess | Denies all new connections to a database or to all databases. |
| HNotifAddCCRecipient | Adds recipients for the notifications sent via the Control Centers (WDBal messaging tool). |
| HNotifAddEmailRecipient | Adds recipients for the notifications sent by email. |
| HNotifConfigure | Specifies and configures the server used to send notifications by the HFSQL server. |
| HNotifDeleteCCRecipient | Deletes the recipients of a notification sent via the Control Centers (WDBal messaging tool). |
| HNotifDeleteEmailRecipient | Deletes the recipients of an email notification. |
| HNotifListCCRecipient | Returns the list of recipients of a notification sent via the Control Centers (WDBal messaging tool). |
| HNotifListEmailRecipient | Returns the list of recipients for a notification by email. |
| HOnServerCall | Customizes the management of message display on the client computer and the management of disconnection from a client computer. |
| HOperationInProgress | Returns the list of automatic operations in progress on an HFSQL server. |
| HPriority | Finds out and modifies the priority of the calling application. |
| HPriorityClient | Modifies the priority of a client application. |
| HReconnect | Performs a reconnection to the server for all the interrupted connections. The uninterrupted connections are not modified. |
| HResetClient | Initializes the structure for managing the Client computers (HClient structure). |
| HResetGroup | Initializes the structure for group management (HGroup) with the default values. |
| HResetUser | Initializes the structure for user management (HUser) with the default values. |
| HRestoreBackup | 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 | Retrieves locally the content of a compressed backup (in ZIP format) performed on an HFSQL server. |
| HRetrieveLog | Creates a text file containing the server logs between two given dates. |
| HSaveParameter | Saves a persistent value on the HFSQL server. |
| HSendMessageToClient | Displays a message on the client computers. |
| HServerMaintenance | Checks and optimizes the system tables of an HFSQL server. |
| HServerStatus | Allows you to find out the status of an HFSQL server (this function uses the MantaManager service). |
| HServerWorkingDir | Returns the path of a temporary directory on the HFSQL server. |
| HSetCache | Used to configure the management of caches in the HFSQL Client/Server engine. |
| HSetServer | Used to find out and modify some settings of HFSQL Client/Server server. |
| HSimulateNetwork | Simulates the operating mode of HFSQL Client/Server on an ADSL or 3G network. |
| HStartServer | Allows you to start an HFSQL server (this function uses the MantaManager service). |
| HStartServerUpdate | Used to immediately start the automatic server update. |
| Gets various statistics on the keys of an HFSQL Client/Server data file. This new function is available from WINDEV Suite SaaS 2025 - Update 2. |
| HStopServer | Stops an HFSQL server. |
| HSuggestKey | Returns a list of keys to add to data files to improve query performance. |
| HSuggestKeyEnd | Finishes collecting information on executed queries. |
| HSuggestKeyStart | Starts collecting information on executed queries. |
| HTransactionIsolation | Configures the isolation level of transactions for a connection to an HFSQL server. |
| HTransactionList | Returns the list of current or interrupted transactions on the server for the specified connection. |
| HTransactionRollbackToSavepoint | Rolls the transaction back to the savepoint. |
| HTransactionSavepoint | Declares a transaction savepoint. |
| HUpdateLink | Updates on the server all the links of an HFSQL Client/Server data file. |
| HUpdateQuery | Creates or updates a query on an HFSQL server. |
| HUpdateSet | Creates or updates a set of procedures on an HFSQL server. |
| HUpdateView | Creates or updates the description of an SQL view or materialized view from the analysis to an HFSQL server. |
| HWatch | Trigger monitoring of write actions (add, modify or delete) performed on a data file present on an HFSQL server. In case of modification, a specific procedure can be triggered. |
| HWatchStop | Stops watching a data file on an HFSQL server. |