HFSQL

HUnlockFile Unlocks the records of a data file. HUnlockRecNum Unlocks a record. HDeclare Declares a description of data file (found in an analysis) in the current project. HDeclareExternal Temporarily imports into the current analysis the description of a file from an existing HFSQL file. HDisconnectClient Displays a message on the client computers and disconnects the application. HDescribeConnection Describes a new connection to an external database. HDescribeFile Describes a data file by programming. HDescribeFullTextIndex Describes a full-text index of data file created by programming. HDescribeLink Describes a link between two files by programming HDescribeItem Describes a file item by programming. HDescribeTrigger Adds or modifies a trigger on a HFSQL data file. HDescribeServerTrigger Adds or modifies a server trigger. HStartServer Used to start a HFSQL server (uses MantaManager). HLast Positions on the last file record according to a search item. HDeactivateFilter Temporarily disables the filter on a data file (view or query). HDeactivateAutoFilter Disables an automatic filter on the linked files when browsing an XML file. HDeactivateTrigger Disables a trigger. HDeactivateServerTrigger Disables a HFSQL Client/Server server trigger on a server. HDeleteTrigger Destroys a trigger. HDeleteServerTrigger Destroys a server trigger. HDeleteView Destroys a view that was created beforehand. HDuplicateRecord Duplicates the record read in a data file: the record found in memory is added into the data file (query or view). HWrite ÉWrites a record into the data file without updating the corre- sponding indexes. HOut Allows you to find out whether the record on which you want to be positioned is located outside the data file, filter, view or query. HRecordToXML Retrieves the structure and the value of the current record and exports them into a character string in XML format. HSendMessageToClient Displays a message on the client computers. HError Returns the number of the last error triggered by the HFSQL en- gine. HErrorLock Used to find out whether a lock error occurred. HErrorDuplicates Allows you to find out whether a duplicate error occurred. HErrorStatusModification Returns the status of a record during a modification conflict HErrorInfo Returns a detailed information about the last error triggered by the HFSQL engine. HErrorIntegrity Allows you to find out whether an integrity error occurred. HErrorModification During a modification conflict, returns the value of a record item. HErrorPassword Allows you to find out whether a password error occurred on this data file. HState Used to find out the record status. HServerStatus Used to find out the status of a HFSQL server. HExecuteProcedure Runs a stored procedure. HExecuteQuery Declares a query created in the query editor to the HFSQL en- gine and runs this query. HExecuteSQLQuery Initializes a query written in SQL language and declares this query to the HFSQL engine. HExecuteScheduledBackup Forces the execution of a scheduled backup. HExecuteView Runs a view that was created beforehand. HExportXML Exports the records from a file (HFSQL or OLE DB), view or query into an XML file. HExtractMemo Extracts the content of a blob item (binary memo) from a physi- cal file. HClose Closes a data file or all the opened data files. HCloseAnalysis Closes the current analysis. HCloseConnection Closes a connection to a database. HFileExist Allows you to find out whether a file exists, or whether a view or a query has been defined. HFilter Defines and enables a filter on a data file, view or query. HFilterStartsWith Defines and enables a “Start with” filter on a file, view or query. HFilterIncludedBetween Defines and enables an “Included between” filter on a file, view or query. HFilterContains Defines and enables a “Contains” filter on a data file, view or query. HFilterIdentical Defines and enables a filter used to find the exact value of a string item. HEndNoDatabaseAccess Re-authorizes the access to one or more databases accessible by a connection. HEndNoModif Unlocks a file locked by the same program with HNoModif. HFlush Forces the operating system of the computer where the data files are found to write data onto the disk. HMergeView Creates a HFSQL view from two views created beforehand HSetRemoteAccess Temporarily disables the remote access in order to access HFSQL Classic data files found locally. HSetCache Allows you to configure the management of caches in the HFSQL Client/Server engine. HSetDuplicates Enables or disables the management of duplicates on a unique key HSetIntegrity Enables or disables the management of an integrity constraint on a file link. HSetLog Enables or disables the log management for a logged file. HSetMemo Used to modify the management mode of memo items. HSetREP Enables or disables the management of .REP file. HSetServer Allows you to find out and modify some settings of HFSQL Client/Server server. HManageTask Enables or disables a scheduled task on a HFSQL Client/Server server. HSetTransaction Enables or disables the management of transactions for one or more files. HSetTrigger Enables or disables the management of triggers. HHistoryModification Returns the modifications made to one or more items of a given record. HImportHF55 Imports a Hyper File 5.5 file into a file in HFSQL Classic format. HImportText Imports a Text file into a data file in HFSQL Classic format. HImportXML Imports an XML file into a file in HFSQL Classic format HInfoAnalysis Returns information about an analysis (WDD file). HInfoLock Returns information about the lock performed on a data file, on a record or on all the records found in a data file. HInfoDatabaseRights Allows you to find out the rights granted to a user or to a group on a database. HInfoFileRights Allows you to find out the rights granted to a user or to a group on a HFSQL Client/Server data file. HInfoServerRights Allows you to find out the rights granted to a user or to a group on a server. HInfoFile Returns the characteristics of a file found on a HFSQL server. HInfoGroup Returns information about the specified group of users. HInfoLog Returns information about the server logs. HInfoMemo Returns the characteristics of binary and text memos. HInfoDatabaseProperty Allows you to find out the properties of a database found on an HFSQL server. HInfoFileProperty Allows you to find out the properties of a data file found on an HFSQL server. HInfoServerProperty Allows you to find out the properties of an HFSQL server. HInfoBackup Returns information about one or more backups performed on a HFSQL Client/Server server. HInfoServer Returns the specified information about the server. HInfoTask Returns the characteristics of a scheduled task. HInfoUser Updates the variables for user management with the informa- tion about the specified user. HNoDatabaseAccess Forbids all the accesses to a database or to all the databases. HNoModif Prevents from modifying a file (for all the programs, including the program that requested the restriction) HLogInfo Adds comments into the log when saving the logged operation. HLogRecreate Used to re-create an empty log. HLogRestart Restarts the log process on a file. HLogStop Stops the log process of a file. HFree Transforms the crossed records of a data file into deleted records. HFreePosition Deletes a position saved by HSavePosition HFreeQuery Frees the resources of a query. HListAnalysis Lists the analyses in HFSQL Classic format available in a given directory. HListDatabase Lists the Client/Server databases associated with a connec- tion. HListKey Lists the keys of a file (a query or a view) recognized by the HFSQL engine. HListConnection Lists the connections currently described in the application. HListStoredElement Lists the elements stored on a HFSQL server (sets of proce- dures, stored procedures or queries). HListFile Lists the files in the current analysis or in a specific analysis recognized by the HFSQL engine. HListGroup Lists the user groups defined for a connection. HListFullTextIndex Lists the full-text indexes of a file (a query or a view) recog- nized by the HFSQL engine. HListLink Lists the links found in the current analysis or in a specific analysis. HListScheduledOptimization Lists the scheduled optimization tasks of HFSQL Client/Server data files for a connection. HListParameter Lists the parameters saved from the procedures stored on the server. HListQueryParameter Lists the parameters of a query created in the query editor HListCustomFolder Lists the custom-folders defined in the analysis. HListProvider Lists the OLE DB providers and/or Native Access installed on the computer. HListREP Lists the assignments for the data files used by the current ap- plication. HFSQL • www.windev.com 19