| |
| <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 | Creates a scheduled task on an HFSQL server: - stored procedure,
- backup,
- optimization,
- refresh of 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 | Makes a backup copy of the content of an HFSQL server: all databases on the server, 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 connection: the higher the level is, the faster the connection will be. |
| <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 a 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 | Deletes a scheduled task found on an HFSQL server: - stored procedure,
- backup,
- optimization,
- refresh of materialized view.
|
| <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>.ExecuteProcedure | Runs a stored procedure. |
| <Connection variable>.ExecuteScheduledBackup | Forces the execution of a scheduled backup. |
| <Connection variable>.ExecuteScheduling | Immediately runs a scheduled task regardless of its schedule: - stored procedure,
- backup,
- optimization,
- refresh of 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 | Allows you to find out the rights granted to a user or to a 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 | Allows you to find out the rights granted to a user or to a 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 | Allows you to find out 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 | Allows you to find out the rights granted to a user or to a 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 the scheduled tasks defined on an HFSQL server: - stored procedure,
- backup,
- optimization,
- refresh of materialized view.
|
| <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 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 | Modifies the rights granted to a user or to a group for a HFSQL Client/Server database. |
| <Connection variable>.ModifyFileProperty | Modifies the properties of an HFSQL data file located on a server. |
| <Connection variable>.ModifyFileRights | Modifies 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 | Sets 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 | Modifies a scheduled task on an HFSQL server: - stored procedure,
- backup,
- optimization,
- refresh of materialized view.
|
| <Connection variable>.ModifyServerProperty | Modifies the properties of an HFSQL server. |
| <Connection variable>.ModifyServerRights | Modifies the rights granted to a user or to a group on a 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 | Modifies 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 mode 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. |
| <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 | Starts watching write actions (add, modify or delete) performed on a file in an HFSQL server. |
| <Source>.WatchStop | Stops watching a data file on an HFSQL server. |