|
|
|
|
|
|
Category: HFSQL Client/Server functions |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Adds an integrity rule between two files on the server. |
|
|
|
|
|
|
Adds a scheduling for full backup (with or without differential backup) on the server defined by the connection. |
|
|
|
|
|
|
Adds an optimization task of HFSQL Client/Server data files. |
|
|
|
|
|
|
Adds a new scheduled item to an HFSQL server: scheduled task (stored procedure), backup, optimization or refresh of a materialized view. |
|
|
|
|
|
|
Adds a scheduled task on the server defined by the connection. |
|
|
|
|
|
|
Adds a user to a database. |
|
|
|
|
|
|
Backs up the contents of an HFSQL server: all server databases, one or more databases, one or more data files. |
|
|
|
|
|
|
Cancels a current backup. |
|
|
|
|
|
|
Checks for the latest version of the HFSQL server that can be automatically updated. |
|
|
|
|
|
|
Returns the quality level of the connection: the higher the level is, the faster the connection is. |
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
Disables an HFSQL Client/Server server trigger on a server. |
|
|
|
|
|
|
Deletes a backup previously created with HBackup. |
|
|
|
|
|
|
Deletes a database located on an HFSQL server. |
|
|
|
|
|
|
Deletes a directory from an HFSQL Client/Server database. |
|
|
|
|
|
|
Deletes HFSQL data files (.fic, .ndx, .ftx, .sdx and .mmo files, if any) from the server. |
|
|
|
|
|
|
Deletes (from the server) a group of users associated with a connection. |
|
|
|
|
|
|
Deletes an integrity rule between two data files on the server. |
|
|
|
|
|
|
Deletes a query (used by stored procedures) from an HFSQL server. |
|
|
|
|
|
|
Deletes a scheduled backup from an HFSQL Client/Server server. |
|
|
|
|
|
|
Deletes a scheduled optimization task from HFSQL Client/Server data files. |
|
|
|
|
|
|
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 operation on an HFSQL server. This operation can be a scheduled task (stored procedure), backup, optimization or a materialized view refresh. |
|
|
|
|
|
|
Deletes a server trigger. |
|
|
|
|
|
|
Deletes a set of stored procedures from an HFSQL server. |
|
|
|
|
|
|
Deletes a scheduled task from an HFSQL Client/Server server. |
|
|
|
|
|
|
Deletes a user associated with a connection to the HFSQL server. |
|
|
|
|
|
|
Adds or modifies a server trigger. |
|
|
|
|
|
|
Displays a message on the Client computer(s) and disconnects the application. |
|
|
|
|
|
|
Deletes a materialized view from the HFSQL server. |
|
|
|
|
|
|
Duplicates the database associated with a connection on an HFSQL server. |
|
|
|
|
|
|
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. |
|
|
|
|
|
|
Forces the execution of a scheduled backup. |
|
|
|
|
|
|
Immediately executes a scheduled item regardless of its scheduling: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. |
|
|
|
|
|
|
Returns information about one or more backups performed on an HFSQL Client/Server server. |
|
|
|
|
|
|
Used to find out the properties of a database on an HFSQL server. |
|
|
|
|
|
|
Gets the rights granted to a user or group on a database. |
|
|
|
|
|
|
Allows you to find out the properties of a data file located in an HFSQL server. |
|
|
|
|
|
|
Gets the rights granted to a user or group on an HFSQL Client/Server data file. |
|
|
|
|
|
|
Returns information about the specified group of users. |
|
|
|
|
|
|
Gets the rights granted to a user or group on an item. |
|
|
|
|
|
|
Returns information about the lock set on a data file, on one or all the records in a data file. |
|
|
|
|
|
|
Returns the specified information about the server. |
|
|
|
|
|
|
Allows you to find out the properties of an HFSQL server. |
|
|
|
|
|
|
Gets the rights granted to a user or group of users on a server. |
|
|
|
|
|
|
Returns the characteristics of a scheduled task in a hScheduledTask variable]. |
|
|
|
|
|
|
Returns information about a materialized view. |
|
|
|
|
|
|
Gets the rights granted to a user or group on an SQL view or on a materialized view. |
|
|
|
|
|
|
Lists the Client/Server databases associated with a connection. |
|
|
|
|
|
|
Returns the list of groups of users defined for a connection. |
|
|
|
|
|
|
Returns the list of parameters saved from the stored procedures on the server.
|
|
|
|
|
|
|
Lists the full and differential backups that have been scheduled on HFSQL Client/Server. |
|
|
|
|
|
|
Lists the scheduled optimization tasks of HFSQL Client/Server data files for a connection. |
|
|
|
|
|
|
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 operation on an HFSQL server. This operation can be a scheduled task (stored procedure), backup, optimization or a materialized view refresh. |
|
|
|
|
|
|
Returns the list of elements stored on an HFSQL server (sets of procedures, stored procedures or queries). |
|
|
|
|
|
|
Lists the scheduled tasks of an HFSQL Client/Server server for a given connection. |
|
|
|
|
|
|
Returns the list of users defined for a connection. |
|
|
|
|
|
|
Returns the list of data files watched by HWatch. |
|
|
|
|
|
|
Reads a parameter that was saved from a stored procedure by HSaveParameter. |
|
|
|
|
|
|
Used to manage the automatic update of HFSQL Client/Server servers by specifying the check frequency regarding the availability of updates. |
|
|
|
|
|
|
Enables or disables a scheduled task on an HFSQL Client/Server server. |
|
|
|
|
|
|
Modifies the properties of a database located on an HFSQL server. |
|
|
|
|
|
|
Sets the rights granted to a user or group for an HFSQL Client/Server database. |
|
|
|
|
|
|
Modifies the properties of an HFSQL data file located on a server. |
|
|
|
|
|
|
Sets the rights granted to a user or group on an HFSQL Client/Server data file. |
|
|
|
|
|
|
Modifies the rights granted to a user or group on an item of an HFSQL Client/Server data file. |
|
|
|
|
|
|
Modifies a backup scheduling. |
|
|
|
|
|
|
Modifies a scheduled optimization task on the HFSQL server defined by the connection. |
|
|
|
|
|
|
Modify a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. |
|
|
|
|
|
|
Modifies the properties of an HFSQL server. |
|
|
|
|
|
|
Sets the rights granted to a user or group on an HFSQL server. |
|
|
|
|
|
|
Modifies a scheduled task on the HFSQL server defined by the connection. |
|
|
|
|
|
|
Sets the rights granted to a user or group on an SQL view or on a materialized view. |
|
|
|
|
|
|
Denies all new connections to a database or to all databases. |
|
|
|
|
|
|
Adds recipients for the notifications sent via the Control Centers (WDBal messaging tool). |
|
|
|
|
|
|
Adds recipients for the notifications sent by email. |
|
|
|
|
|
|
Specifies and configures the server used to send notifications by the HFSQL server. |
|
|
|
|
|
|
Deletes the recipients of a notification sent via the Control Centers (WDBal messaging tool). |
|
|
|
|
|
|
Deletes the recipients of an email notification. |
|
|
|
|
|
|
Returns the list of recipients of a notification sent via the Control Centers (WDBal messaging tool). |
|
|
|
|
|
|
Returns the list of recipients for a notification by email. |
|
|
|
|
|
|
Returns the list of automatic operations in progress on an HFSQL server. |
|
|
|
|
|
|
Finds out and modifies the priority of the calling application. |
|
|
|
|
|
|
Modifies the priority of a client application. |
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
Retrieves locally the content of a compressed backup (in ZIP format) performed on an HFSQL server. |
|
|
|
|
|
|
Creates a text file containing the server logs between two given dates. |
|
|
|
|
|
|
Saves a persistent value on the HFSQL server. |
|
|
|
|
|
|
Displays a message on the client computers. |
|
|
|
|
|
|
Checks and optimizes the system tables of an HFSQL server. |
|
|
|
|
|
|
Used to find out and modify some settings of HFSQL Client/Server server. |
|
|
|
|
|
|
Simulates the operating mode of HFSQL Client/Server on an ADSL or 3G network. |
|
|
|
|
|
|
Used to immediately start the automatic server update. |
|
|
|
|
|
|
Configures the isolation level of transactions for a connection to an HFSQL server. |
|
|
|
|
|
|
Returns the list of current or interrupted transactions on the server for the specified connection. |
|
|
|
|
|
|
Rolls the transaction back to the savepoint. |
|
|
|
|
|
|
Declares a transaction savepoint. |
|
|
|
|
|
|
Creates or updates a query on an HFSQL server. |
|
|
|
|
|
|
Creates or updates a set of procedures on an HFSQL server. |
|
|
|
|
|
|
Creates or updates the description of an SQL view or materialized view from the analysis to an HFSQL server. |
|
|
|
|
|
|
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. |
|
|
|
|
|
|
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. |
|
|
|
|
|
|
Rebuilds the index of an HFSQL Client/Server data file (".NDX" file). This operation is asynchronous, i.e., it is performed on the server and does not block the client side. This new function is available from WINDEV Suite SaaS 2025 - Update 2. |
|
|
|
|
|
|
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. |
|
|
|
|
|
|
Changes the password of an HFSQL Classic or HFSQL Client/Server data file. |
|
|
|
|
|
|
Returns information about the lock set on a data file, on one or all the records in a data file. |
|
|
|
|
|
|
Updates on the server all the links of an HFSQL Client/Server data file. |
|
|
|
|
|
|
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. |
|
|
|
|
|
|
Stops watching a data file on an HFSQL server. |
|
|
|
|
|
|
Unblocks a user account blocked by too many unsuccessful login attempts. This new function is available from WINDEV Suite SaaS 2025 - Update 3. |
|
|
|
|
|
|
Verifies that the password security policy associated with the HFSQL server is respected for each user account. This new function is available from WINDEV Suite SaaS 2025 - Update 3. |
|
|
|
|
|
|
Retrieves the security policy of an HFSQL server.This new feature is available from version 2025 Update 3. |
|
|
|
|
|
|
Modifies the password security policy of an HFSQL server. This new function is available from WINDEV Suite SaaS 2025 - Update 3. |
|
|
|
|
|
|
Adds an integrity rule between two data files on the server. |
|
|
|
|
|
|
Adds a scheduling for full backup (with or without differential backup) on the server defined by the connection. |
|
|
|
|
|
|
Adds an optimization task of HFSQL Client/Server data files. |
|
|
|
|
|
|
Adds a new scheduled item to an HFSQL server: scheduled task (stored procedure), backup, optimization or refresh of a materialized view. |
|
|
|
|
|
|
Adds a scheduled task on the server defined by the connection. |
|
|
|
|
|
|
Adds a user to a database. |
|
|
|
|
|
|
Backs up the contents of an HFSQL server: all server databases, one or more databases, one or more data files. |
|
|
|
|
|
|
Cancels a current backup. |
|
|
|
|
|
|
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. |
|
|
|
|
|
|
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. |
|
|
|
|
|
|
Clears and destroys the temporary directory previously created when HServerWorkingDir was executed. |
|
|
|
|
|
|
Returns the quality level of the connection: the higher the level is, the faster the connection is. |
|
|
|
|
|
|
Usage example of the HCopyFile function |
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
The HCS.FrameSize variable is used to resize the outgoing data frame. |
|
|
|
|
|
|
The HCS.Timeout variable is used to modify the connection timeout: - for the connections established by HOpenConnection.
- for the automatic connection openings.
|
|
|
|
|
|
|
Deletes a backup previously created with HBackup. |
|
|
|
|
|
|
Deletes a database located on an HFSQL server. |
|
|
|
|
|
|
Deletes a directory from an HFSQL Client/Server database. |
|
|
|
|
|
|
Deletes HFSQL data files (.fic, .ndx, .ftx, .sdx and .mmo files, if any) from the server. |
|
|
|
|
|
|
Deletes (from the server) a group of users associated with a connection. |
|
|
|
|
|
|
Deletes an integrity rule between two data files on the server. |
|
|
|
|
|
|
Deletes a query (used by stored procedures) from an HFSQL server. |
|
|
|
|
|
|
Deletes a scheduled backup from an HFSQL Client/Server server. |
|
|
|
|
|
|
Deletes a scheduled optimization task from HFSQL Client/Server data files. |
|
|
|
|
|
|
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. |
|
|
|
|
|
|
Deletes a set of stored procedures from an HFSQL server. |
|
|
|
|
|
|
Deletes a scheduled task from an HFSQL Client/Server server. |
|
|
|
|
|
|
Deletes a user associated with a connection to the HFSQL server. |
|
|
|
|
|
|
Displays a message on the Client computer(s) and disconnects the application. |
|
|
|
|
|
|
Deletes a materialized view from the HFSQL server. |
|
|
|
|
|
|
Duplicates the database associated with a connection on an HFSQL server. |
|
|
|
|
|
|
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. |
|
|
|
|
|
|
Forces the execution of a scheduled backup. |
|
|
|
|
|
|
Immediately executes a scheduled item regardless of its scheduling: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. |
|
|
|
|
|
|
Several HFSQL functions are used to manage the HFSQL Client/Server data... |
|
|
|
|
|
|
Several HFSQL functions are used to manage the HFSQL Client/Server data... |
|
|
|
|
|
|
Scheduled optimization is a mechanism for automatically optimizing your database... |
|
|
|
|
|
|
Returns information about one or more backups performed on an HFSQL Client/Server server. |
|
|
|
|
|
|
Used to find out the properties of a database on an HFSQL server. |
|
|
|
|
|
|
Usage example of HInfoDatabaseRights |
|
|
|
|
|
|
Gets the rights granted to a user or group on a database. |
|
|
|
|
|
|
Allows you to find out the properties of a data file located in an HFSQL server. |
|
|
|
|
|
|
Usage example of the HInfoFileRights function |
|
|
|
|
|
|
Gets the rights granted to a user or group on an HFSQL Client/Server data file. |
|
|
|
|
|
|
Returns information about the specified group of users. |
|
|
|
|
|
|
Gets the rights granted to a user or group on an item. |
|
|
|
|
|
|
Returns information about the lock set on a data file, on one or all the records in a data file. |
|
|
|
|
|
|
Returns information about the server logs. |
|
|
|
|
|
|
Returns the specified information about the server. |
|
|
|
|
|
|
Allows you to find out the properties of an HFSQL server. |
|
|
|
|
|
|
Usage example of the HInfoServerRights function |
|
|
|
|
|
|
Gets the rights granted to a user or group of users on a server. |
|
|
|
|
|
|
Returns the characteristics of a scheduled task in a hScheduledTask variable]. |
|
|
|
|
|
|
Returns information about a materialized view. |
|
|
|
|
|
|
Gets the rights granted to a user or group on an SQL view or on a materialized view. |
|
|
|
|
|
|
Lists users currently connected to one or more data files handled by a Client/Server connection. |
|
|
|
|
|
|
Lists the Client/Server databases associated with a connection. |
|
|
|
|
|
|
Returns the list of groups of users defined for a connection. |
|
|
|
|
|
|
Returns the list of parameters saved from the stored procedures on the server.
|
|
|
|
|
|
|
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. |
|
|
|
|
|
|
Lists the full and differential backups that have been scheduled on HFSQL Client/Server. |
|
|
|
|
|
|
Lists the scheduled optimization tasks of HFSQL Client/Server data files for a connection. |
|
|
|
|
|
|
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. |
|
|
|
|
|
|
Lists the HFSQL servers installed on a computer. |
|
|
|
|
|
|
Returns the list of elements stored on an HFSQL server (sets of procedures, stored procedures or queries). |
|
|
|
|
|
|
Lists the scheduled tasks of an HFSQL Client/Server server for a given connection. |
|
|
|
|
|
|
Returns the list of users defined for a connection. |
|
|
|
|
|
|
Returns the list of data files watched by HWatch. |
|
|
|
|
|
|
Reads a parameter that was saved from a stored procedure by HSaveParameter. |
|
|
|
|
|
|
Allows you to manage the automatic update of HFSQL Client/Server servers and to define how often to check for updates. |
|
|
|
|
|
|
Enables or disables a scheduled task on an HFSQL Client/Server server. |
|
|
|
|
|
|
Modifies the properties of a database located on an HFSQL server. |
|
|
|
|
|
|
Sets the rights granted to a user or group for an HFSQL Client/Server database. |
|
|
|
|
|
|
Modifies the properties of an HFSQL data file located on a server. |
|
|
|
|
|
|
Sets the rights granted to a user or group on an HFSQL Client/Server data file. |
|
|
|
|
|
|
Modifies the rights granted to a user or group on an item of an HFSQL Client/Server data file. |
|
|
|
|
|
|
Modifies a backup scheduling. |
|
|
|
|
|
|
Modifies a scheduled optimization task on the HFSQL server defined by the connection. |
|
|
|
|
|
|
Modify a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. |
|
|
|
|
|
|
Modifies the properties of an HFSQL server. |
|
|
|
|
|
|
Sets the rights granted to a user or group on an HFSQL server. |
|
|
|
|
|
|
Modifies a scheduled task on the HFSQL server defined by the connection. |
|
|
|
|
|
|
Sets the rights granted to a user or group on an SQL view or on a materialized view. |
|
|
|
|
|
|
Denies all new connections to a database or to all databases. |
|
|
|
|
|
|
Adds recipients for the notifications sent via the Control Centers (WDBal messaging tool). |
|
|
|
|
|
|
Adds recipients for the notifications sent by email. |
|
|
|
|
|
|
Specifies and configures the server used to send notifications by the HFSQL server. |
|
|
|
|
|
|
Deletes the recipients of a notification sent via the Control Centers (WDBal messaging tool). |
|
|
|
|
|
|
Deletes the recipients of an email notification. |
|
|
|
|
|
|
Returns the list of recipients of a notification sent via the Control Centers (WDBal messaging tool). |
|
|
|
|
|
|
Returns the list of recipients for a notification by email. |
|
|
|
|
|
|
Customizes the management of message display on the client computer and the management of disconnection from a client computer. |
|
|
|
|
|
|
Returns the list of automatic operations in progress on an HFSQL server. |
|
|
|
|
|
|
Finds out and modifies the priority of the calling application. |
|
|
|
|
|
|
Modifies the priority of a client application. |
|
|
|
|
|
|
Performs a reconnection to the server for all the interrupted connections. The uninterrupted connections are not modified. |
|
|
|
|
|
|
Rebuilds the index of an HFSQL Client/Server data file (".NDX" file). This operation is asynchronous, i.e., it is performed on the server and does not block the client side. This new function is available from WINDEV Suite SaaS 2025 - Update 2. |
|
|
|
|
|
|
Initializes the structure for managing the Client computers (HClient structure). |
|
|
|
|
|
|
Initializes the structure for group management (HGroup) with the default values. |
|
|
|
|
|
|
Initializes the structure for user management (HUser) with the default values. |
|
|
|
|
|
|
Usage example of the 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.
|
|
|
|
|
|
|
Retrieves locally the content of a compressed backup (in ZIP format) performed on an HFSQL server. |
|
|
|
|
|
|
Creates a text file containing the server logs between two given dates. |
|
|
|
|
|
|
Saves a persistent value on the HFSQL server. |
|
|
|
|
|
|
The type hSecurityPolicy type lets you define all the advanced features of a password security policy set up for an HFSQL Client/Server server. This new variable type is available from WINDEV Suite SaaS 2025 Update 3. |
|
|
|
|
|
|
Verifies that the password security policy associated with the HFSQL server is respected for each user account. This new function is available from WINDEV Suite SaaS 2025 - Update 3. |
|
|
|
|
|
|
Retrieves the security policy of an HFSQL server. This new function is available from WINDEV Suite SaaS 2025 - Update 3. |
|
|
|
|
|
|
Modifies the password security policy of an HFSQL server. This new function is available from WINDEV Suite SaaS 2025 - Update 3. |
|
|
|
|
|
|
Unblocks a user account blocked by too many unsuccessful login attempts. This new function is available from WINDEV Suite SaaS 2025 - Update 3. |
|
|
|
|
|
|
Displays a message on the client computers. |
|
|
|
|
|
|
Checks and optimizes the system tables of an HFSQL server. |
|
|
|
|
|
|
The hServerOperation type is used to get the characteristics of an operation performed on an HFSQL server. |
|
|
|
|
|
|
Allows you to find out the status of an HFSQL server (this function uses the MantaManager service). |
|
|
|
|
|
|
Returns the path of a temporary directory on the HFSQL server. |
|
|
|
|
|
|
Used to configure the management of caches in the HFSQL Client/Server engine. |
|
|
|
|
|
|
Used to find out and modify some settings of HFSQL Client/Server server. |
|
|
|
|
|
|
Simulates the operating mode of HFSQL Client/Server on an ADSL or 3G network. |
|
|
|
|
|
|
Allows you to start an HFSQL server (this function uses the MantaManager service). |
|
|
|
|
|
|
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. |
|
|
|
|
|
|
Returns a list of keys to add to data files to improve query performance. |
|
|
|
|
|
|
Finishes collecting information on executed queries. |
|
|
|
|
|
|
Starts collecting information on executed queries. |
|
|
|
|
|
|
Rolls the transaction back to the savepoint. |
|
|
|
|
|
|
Declares a transaction savepoint. |
|
|
|
|
|
|
Updates on the server all the links of an HFSQL Client/Server data file. |
|
|
|
|
|
|
Creates or updates a query on an HFSQL server. |
|
|
|
|
|
|
Creates or updates a set of procedures on an HFSQL server. |
|
|
|
|
|
|
Creates or updates the description of an SQL view or materialized view from the analysis to an HFSQL server. |
|
|
|
|
|
|
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. |
|
|
|
|
|
|
Stops watching a data file on an HFSQL server. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|