<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 data files. <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 data files. <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 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 (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 data files (.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 data files 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 data files. <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 data file located in an HFSQL server. <Connection variable>.InfoFileRights (Function) Gets the rights granted to a user or group on an HFSQL Client/Server data file. <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 data file, on one or all the records in a data file. <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 data files 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 the list of files watched by HWatch. <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 data file located on a server. <Connection variable>.ModifyFileRights (Function) Sets the rights granted to a user or group on an HFSQL Client/Server data file. <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 data file. <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. <Source>.ChangePassword (Function) Changes the password of an HFSQL Classic or HFSQL Client/Server data file. <Source>.InfoLock (Function) Returns information about the lock set on a data file, on one or all the records in a data file. <Source>.UpdateLink (Function) Updates on the server all the links of an HFSQL Client/Server data file. <Source>.Watch (Function) Starts watching write actions (add, modify or delete) performed on a file in an HFSQL server. <Source>.WatchStop (Function) Stops watching a data file on an HFSQL server. HAddGroup (Function) Adds a group of users. HAddLink (Function) Adds an integrity rule between two data files 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 data files. 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 data files. HCancelBackup (Function) Cancels a current backup. HChangePassword (Function) Changes the password of an HFSQL Classic or HFSQL Client/Server data file. 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 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. 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 data files (.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 data files 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 data files. 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. 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 data file 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 data file. 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 data file, on one or all the records in a data file. 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 (Example) Usage example of the HInfoServerRights function 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 data files 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. 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 data files 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 operation on an HFSQL server. This operation 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 the list of files watched by HWatch. 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 data file located on a server. HModifyFileRights (Function) Sets the rights granted to a user or group on an HFSQL Client/Server data file. 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 data file. 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 (Example) Usage example of the HRestoreBackup function 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. HStopServer (Function) Stops an HFSQL server. HSuggestKey (Function) Returns a list of keys to add to data files 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 data file. 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 analysis to an HFSQL server. HWatch (Function) Starts watching write actions (add, modify or delete) performed on a file in an HFSQL server. HWatchStop (Function) Stops watching a data file on an HFSQL server. WLanguage procedure 1 document