HFSQL

HListItem List the items in a file (a query or a view) recognized by the HFSQL engine. HListScheduledBackup Lists the full and differential backups that have been sched- uled on a HFSQL Client/Server server. HListServer Lists the HFSQL servers installed on a computer. HListTask Returns the list of scheduled tasks found on a HFSQL Client/Server server for a given connection. HListTrigger Lists the triggers applied to one or more HFSQL data files. HListServerTrigger Lists the different triggers available on a connection or on one of the connection files. HListUser Lists the users defined for a connection. HListConnectedUser Lists the users currently connected to one or more files han- dled by a Client/Server connection. HRead Reads a record in a file according to a given record number. HReadLast Positions on the last file record according to a search item. HReadPrevious Positions on the previous file record according to a search item. HReadFirst Positions on the first file record according to a search item. HReadSeek Positions on the first file record whose value for a specific item is greater than or equal to a sought value (generic search). HReadSeekLast Positions on the last file record whose value for a specific item is less than or equal to a sought value (exact-match search). HReadSeekFirst Positions on the first file record whose value for a specific item is strictly equal to a sought value (exact-match search). HReadNext Positions on next file record according to a search item. HMigrateLinkedCompositeKey Migrates the values of the linked composite keys coming from a file in Hyper File 5.5 format to the HFSQL Classic format. HRefreshSet Creates or refreshes a set of procedures on a server HRefreshQuery Creates or refreshes a query on a HFSQL server. HMode Changes the mode for locking data files. HModify Modifies the specified record or the record found in memory in the data file (query or view). HModifyDatabaseRights Modifies the rights granted to a user or to a group for a HFSQL Client/Server database. HModifyFileRights Modifies the rights granted to a user or to a group on a HFSQL Client/Server data file. HModifyServerRights Modifies the rights granted to a user or to a group on a HFSQL server. HModifyGroup Modifies the group information according to the elements found in the corresponding variables for group management. HModifyScheduledOptimization Modifies a scheduled optimization task on the HFSQL server defined by the connection. HModifyDatabaseProperty Modifies the properties of a database found on a HFSQL server. HModifyFileProperty Modifies the properties of a HFSQL file found on a server. HModifyServerProperty Modifies the properties of a HFSQL server. HModifyScheduledBackup Modifies a backup scheduling. HModifyStructure Updates the structure of a HFSQL data file by performing a syn- chronization of data. HModifyTask Modifies a scheduled task on the HFSQL server defined by the connection. HModifyUser Modifies the user information according to the elements found in the corresponding variables for user management. HNbRec Returns the number of records in a file, a query or a HFSQL view: active records, crossed records, deleted records, etc. HNotifAddCCRecipient Adds recipients for the notifications sent via the Control Cen- ters. HNotifAddEmailRecipient Adds recipients for the notifications sent by email. HNotifConfigure Specifies and configures the server used to send notifications by the HFSQL server. HNotifListCCRecipient Returns the list of recipients for a notification sent via the Con- trol Centers. HNotifListEmailRecipient Returns the list of recipients for a notification by email. HNotifDeleteCCRecipient Deletes the recipients of a notification sent via the Control Cen- ters. HNotifDeleteEmailRecipient Deletes the recipients of a notification by email. HRecNum Returns the number of the current record in the HFSQL data file or in the HFSQL view. HOptimize Uses idle periods (period without processing) to optimize the queries and the read operations that will be run thereafter. HOptimizeQuery Optimizes the selection queries by using idle times (period without processing) HOpen Opens a data file. HOpenAnalysis Opens an analysis in HFSQL Classic format. HOpenConnection Opens a connection to a specific database. HPass Defines the password used to create or open a data file. HGetCurrentPosition Returns the approximate position of current record in the data file. HSetPosition Positions on a record from the approximate position of one of its items. HPost Stores a unique computer number or identifier in order to use the log and transactions in network. HPrevious Positions on the previous file record according to a search item. HFirst Positions on the first record of a data file according to the spec- ified search item. HPrepareQuery Initializes a query and declares this query to the database server in order to optimize the next executions of this query. HPrepareSQLQuery Initializes a query written in SQL and declares this query to the database server in order to optimize the next executions of this query. HPriority Allows you to find out and modify the priority of the calling ap- plication. HPriorityClient Modifies the priority of a client application. HClearWorkingDir Clears and destroys the temporary directory that was previ- ously created during the execution of HServerWorkingDir. HConnectionQuality Returns the quality level of connection: the higher the level is, the faster the connection will be. HCross Crosses a record in a data file. HReset Initializes one or more variables of the items found in a data file with their default values. HResetClient Initializes the structure for managing the client computers (HClient structure) HResetGroup Initializes the structure for group management with the default values. HResetUser Initializes the structure for user management with the default values. HSeek Points to the first file record whose value for a specific item is greater than or equal to a sought value (generic search by de- fault). HSeekLast Positions on the last file record whose value for a specific item is less than or equal to a sought value. HSeekFirst Positions on the first file record whose value for a specific item is greater than or equal to a sought value. HReconnect Establishes a reconnection to the server for all the interrupted connections. HBackward Moves backward several records from the current position in the data file, according to a specified item. HRetrieveRecord Returns the content of the current record (in a file, a view or a query, ...). HRetrieveLog Creates a text file containing the server logs between two given dates. HRetrieveItem Returns the content of an item found in the current record (in the data file, view, query, ...). HRegenerateFile Regenerates a data file from its log. HIndexingInProgress Indicates that a data file is currently re-indexed and returns the percentage of the file already re-indexed. HIndex Rebuilds the index of a data file HServerWorkingDir Returns the path of a temporary directory on the server. HRestoreBackup Restores a backup performed by the HBackup function or via the HFSQL Control Center HRestorePosition Restores the context of a previously saved data file. HRSAddConfig Adds a replication between two HFSQL server onto the master server. HRSExecute Immediately runs a recurring replication between HFSQL servers: the replication is triggered before the scheduling HRSInfo Allows you to read the configuration of the replication for a HFSQL server taking part in one or more replications. HRSInit Configures a HFSQL server in order for this server to be a mas- ter server or a subscriber server for a replication between HFSQL servers. HRSListConfig Lists the replications available on a master HFSQL server. HRSModifyConfig Modifies some parameters of an existing replication between two HFSQL servers. HRSDeleteConfig Deletes a replication between two HFSQL servers. HBackup Saves the content of a HFSQL server. HSaveParameter Saves a persistent value from a stored procedure. HSavePosition Stores the current context of a data file. HSecurity Enables or disables the security mechanism.. HSimulateNetwork Simulates the operating mode of HFSQL Client/Server on an ADSL or 3G network. HStatCalculate Performs statistical calculations on the keys of a file. HStatDate Returns the date of the last update for the index statistics HStatTime Returns the time of the last update for the index statistics HStatNbDuplicates Returns the number of duplicates for a given key item. HStatNbRec Returns the number of entries for a given key item. HStatNbRecRange Returns an estimate regarding the number of entries for a given key item in a given interval of values. HSubstDir Associates the data directory specified in the analysis with a directory found on disk. HNext Positions on next file record according to a search item. HDelete Deletes a record from a data file (query or view). HDeleteDatabase Deletes a database found on a HFSQL server. HDeleteSet Deletes a set of stored procedures from a HFSQL server. HDeleteFile Deletes the HFSQL data files (.fic, .ndx, .ftx and .mmo files if HFSQL • www.windev.com 20