| |
| <Connection variable>.ActivateServerTrigger | Re-enables a server trigger that was disabled by <Connection variable>.DeactivateServerTrigger. |
| <Connection variable>.AddGroup | Adds a group of users. |
| <Connection variable>.AddLink | Adds an integrity rule between two files on the server. |
| <Connection variable>.AddScheduledBackup | Adds a scheduling for full backup (with or without differential backup) on the server defined by the connection. |
| <Connection variable>.AddScheduledOptimization | Adds an optimization task of HFSQL Client/Server data files. |
| <Connection variable>.AddScheduling | Adds a new scheduled item to an HFSQL server: scheduled task (stored procedure), backup, optimization or refresh of a materialized view. |
| <Connection variable>.AddTask | Adds a scheduled task on the server defined by the connection. |
| <Connection variable>.AddUser | Adds a user to a database. |
| <Connection variable>.Backup | Backs up the contents of an HFSQL server: all server databases, one or more databases, one or more data files. |
| <Connection variable>.CancelBackup | Cancels a current backup. |
| <Connection variable>.CheckServerUpdate | Checks for the latest version of the HFSQL server that can be automatically updated. |
| <Connection variable>.ConnectionQuality | Returns the quality level of the connection: the higher the level is, the faster the connection is. |
| <Connection variable>.CopyFile | 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.
|
| <Connection variable>.DeactivateServerTrigger | Disables an HFSQL Client/Server server trigger on a server. |
| <Connection variable>.DeleteBackup | Deletes a backup previously created with <Connection variable>.Backup. |
| <Connection variable>.DeleteDatabase | Deletes a database located on an HFSQL server. |
| <Connection variable>.DeleteDirectory | Deletes a directory from an HFSQL Client/Server database. |
| <Connection variable>.DeleteFile | Deletes HFSQL data files (.fic, .ndx, .ftx, .sdx and .mmo files, if any) from the server. |
| <Connection variable>.DeleteGroup | Deletes (from the server) a group of users associated with a connection. |
| <Connection variable>.DeleteLink | Deletes an integrity rule between two data files on the server. |
| <Connection variable>.DeleteParameter | Deletes a parameter previously saved by <Connection variable>.SaveParameter. |
| <Connection variable>.DeleteQuery | Deletes a query (used by stored procedures) from an HFSQL server. |
| <Connection variable>.DeleteScheduledBackup | Deletes a scheduled backup from an HFSQL Client/Server server. |
| <Connection variable>.DeleteScheduledOptimization | Deletes a scheduled optimization task from HFSQL Client/Server data files. |
| <Connection variable>.DeleteScheduling | 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. |
| <Connection variable>.DeleteServerTrigger | Deletes a server trigger. |
| <Connection variable>.DeleteSet | Deletes a set of stored procedures from an HFSQL server. |
| <Connection variable>.DeleteTask | Deletes a scheduled task from an HFSQL Client/Server server. |
| <Connection variable>.DeleteUser | Deletes a user associated with a connection to the HFSQL server. |
| <Connection variable>.DescribeServerTrigger | Adds or modifies a server trigger. |
| <Connection variable>.DisconnectClient | Displays a message on the Client computer(s) and disconnects the application. |
| <Connection variable>.DropView | Deletes a materialized view from the HFSQL server. |
| <Connection variable>.DuplicateDatabase | Duplicates the database associated with a connection on an HFSQL server. |
| <Connection variable>.EndNoDatabaseAccess | Re-allows the access (which means the connection) to one or more databases accessible via a connection. |
| <Connection variable>.ExecuteAsynchronousProcedure | Executes a stored procedure in asynchronous mode. This new function is available from WINDEV Suite SaaS 2025 Update 2. |
| <Connection variable>.ExecuteProcedure | Runs a stored procedure. |
| <Connection variable>.ExecuteScheduledBackup | Forces the execution of a scheduled backup. |
| <Connection variable>.ExecuteScheduling | Immediately executes a scheduled item regardless of its scheduling: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. |
| <Connection variable>.InfoBackup | Returns information about one or more backups performed on an HFSQL Client/Server server. |
| <Connection variable>.InfoDatabaseProperty | Used to find out the properties of a database on an HFSQL server. |
| <Connection variable>.InfoDatabaseRights | Gets the rights granted to a user or group on a database. |
| <Connection variable>.InfoFileProperty | Allows you to find out the properties of a data file located in an HFSQL server. |
| <Connection variable>.InfoFileRights | Gets the rights granted to a user or group on an HFSQL Client/Server data file. |
| <Connection variable>.InfoGroup | Returns information about the specified group of users. |
| <Connection variable>.InfoItemRights | Gets the rights granted to a user or group on an item. |
| <Connection variable>.InfoLock | Returns information about the lock set on a data file, on one or all the records in a data file. |
| <Connection variable>.InfoServer | Returns the specified information about the server. |
| <Connection variable>.InfoServerProperty | Allows you to find out the properties of an HFSQL server. |
| <Connection variable>.InfoServerRights | Gets the rights granted to a user or group of users on a server. |
| <Connection variable>.InfoTask | Returns the characteristics of a scheduled task in a hScheduledTask variable]. |
| <Connection variable>.InfoUser | Updates the variables for user management with the information regarding the specified user. |
| <Connection variable>.InfoView | Returns information about a materialized view. |
| <Connection variable>.InfoViewRights | Gets the rights granted to a user or group on an SQL view or on a materialized view. |
| <Connection variable>.ListDatabase | Lists the Client/Server databases associated with a connection. |
| <Connection variable>.ListGroup | Returns the list of groups of users defined for a connection. |
| <Connection variable>.ListParameter | Returns the list of parameters saved from the stored procedures on the server. |
| <Connection variable>.ListScheduledBackup | Lists the full and differential backups that have been scheduled on HFSQL Client/Server. |
| <Connection variable>.ListScheduledOptimization | Lists the scheduled optimization tasks of HFSQL Client/Server data files for a connection. |
| <Connection variable>.ListScheduling | 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. |
| <Connection variable>.ListStoredElement | Returns the list of elements stored on an HFSQL server (sets of procedures, stored procedures or queries). |
| <Connection variable>.ListTask | Lists the scheduled tasks of an HFSQL Client/Server server for a given connection. |
| <Connection variable>.ListUser | Returns the list of users defined for a connection. |
| <Connection variable>.ListWatchedFiles | Returns the list of data files watched by <Source>.Watch. |
| <Connection variable>.LoadParameter | Reads a parameter that was saved from a stored procedure by <Connection variable>.SaveParameter. |
| <Connection variable>.ManageServerUpdate | Used to manage the automatic update of HFSQL Client/Server servers by specifying the check frequency regarding the availability of updates. |
| <Connection variable>.ManageTask | Enables or disables a scheduled task on an HFSQL Client/Server server. |
| <Connection variable>.ModifyDatabaseProperty | Modifies the properties of a database located on an HFSQL server. |
| <Connection variable>.ModifyDatabaseRights | Sets the rights granted to a user or group for an HFSQL Client/Server database. |
| <Connection variable>.ModifyFileProperty | Modifies the properties of an HFSQL data file located on a server. |
| <Connection variable>.ModifyFileRights | Sets the rights granted to a user or group on an HFSQL Client/Server data file. |
| <Connection variable>.ModifyGroup | Modifies the group information according to the elements found in the corresponding variables for group management. |
| <Connection variable>.ModifyItemRights | Modifies the rights granted to a user or group on an item of an HFSQL Client/Server data file. |
| <Connection variable>.ModifyScheduledBackup | Modifies a backup scheduling. |
| <Connection variable>.ModifyScheduledOptimization | Modifies a scheduled optimization task on the HFSQL server defined by the connection. |
| <Connection variable>.ModifyScheduling | Modify a scheduled item on an HFSQL server: scheduled task (stored procedure), backup, optimization, refresh of a materialized view. |
| <Connection variable>.ModifyServerProperty | Modifies the properties of an HFSQL server. |
| <Connection variable>.ModifyServerRights | Sets the rights granted to a user or group on an HFSQL server. |
| <Connection variable>.ModifyTask | Modifies a scheduled task on the HFSQL server defined by the connection. |
| <Connection variable>.ModifyUser | Modifies the information about a user according to the elements found in the corresponding variables for user management. |
| <Connection variable>.ModifyViewRights | Sets the rights granted to a user or group on an SQL view or on a materialized view. |
| <Connection variable>.NoDatabaseAccess | Denies all new connections to a database or to all databases. |
| <Connection variable>.NotifAddCCRecipient | Adds recipients for the notifications sent via the Control Centers (WDBal messaging tool). |
| <Connection variable>.NotifAddEmailRecipient | Adds recipients for the notifications sent by email. |
| <Connection variable>.NotifConfigure | Specifies and configures the server used to send notifications by the HFSQL server. |
| <Connection variable>.NotifDeleteCCRecipient | Deletes the recipients of a notification sent via the Control Centers (WDBal messaging tool). |
| <Connection variable>.NotifDeleteEmailRecipient | Deletes the recipients of an email notification. |
| <Connection variable>.NotifListCCRecipient | Returns the list of recipients of a notification sent via the Control Centers (WDBal messaging tool). |
| <Connection variable>.NotifListEmailRecipient | Returns the list of recipients for a notification by email. |
| <Connection variable>.OperationInProgress | Returns the list of automatic operations in progress on an HFSQL server. |
| <Connection variable>.Priority | Finds out and modifies the priority of the calling application. |
| <Connection variable>.PriorityClient | Modifies the priority of a client application. |
| <Connection variable>.RestoreBackup | Used to restore: |
| <Connection variable>.RetrieveBackup | Retrieves locally the content of a compressed backup (in ZIP format) performed on an HFSQL server. |
| <Connection variable>.RetrieveLog | Creates a text file containing the server logs between two given dates. |
| <Connection variable>.SaveParameter | Saves a persistent value on the HFSQL server. |
| <Connection variable>.SendMessageToClient | Displays a message on the client computers. |
| <Connection variable>.ServerMaintenance | Checks and optimizes the system tables of an HFSQL server. |
| <Connection variable>.SetServer | Used to find out and modify some settings of HFSQL Client/Server server. |
| <Connection variable>.SimulateNetwork | Simulates the operating mode of HFSQL Client/Server on an ADSL or 3G network. |
| <Connection variable>.StartServerUpdate | Used to immediately start the automatic server update. |
| <Connection variable>.StopServer | Stops an HFSQL server. |
| <Connection variable>.TransactionIsolation | Configures the isolation level of transactions for a connection to an HFSQL server. |
| <Connection variable>.TransactionList | Returns the list of current or interrupted transactions on the server for the specified connection. |
| <Connection variable>.TransactionRollbackToSavepoint | Rolls the transaction back to the savepoint. |
| <Connection variable>.TransactionSavepoint | Declares a transaction savepoint. |
| <Connection variable>.UpdateQuery | Creates or updates a query on an HFSQL server. |
| <Connection variable>.UpdateSet | Creates or updates a set of procedures on an HFSQL server. |
| <Connection variable>.UpdateView | Creates or updates the description of an SQL view or materialized view from the analysis to an HFSQL server. |
| <HFSQL connection>.CheckIndexAsynchronous | 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. |
| <HFSQL connection>.CheckMemoAsynchronous | 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. |
| <HFSQL connection>.ListReindexingHistory | 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. |
| <HFSQL connection>.ReindexAsynchronous | 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. |
| <HFSQL connection>.StatCalculateAsynchronous | 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. |
| <Source>.ChangePassword | Changes the password of an HFSQL Classic or HFSQL Client/Server data file. |
| <Source>.InfoLock | Returns information about the lock set on a data file, on one or all the records in a data file. |
| <Source>.UpdateLink | Updates on the server all the links of an HFSQL Client/Server data file. |
| <Source>.Watch | 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. |
| <Source>.WatchStop | Stops watching a data file on an HFSQL server. |
| <Variable Connexion>AccountUnlockSecurityPolicy | Unblocks a user account blocked by too many unsuccessful login attempts. This new function is available from WINDEV Suite SaaS 2025 - Update 3. |
| <Variable Connexion>PolicySecurityVerify | 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. |
| <Variable Connexion>SafetyPolicyRecover | Retrieves the security policy of an HFSQL server.This new feature is available from version 2025 Update 3. |
| <Variable Connexion>SecurityPolicyModify | Modifies the password security policy of an HFSQL server. This new function is available from WINDEV Suite SaaS 2025 - Update 3. |