Some WLanguage functions are not available in Reports & Queries. These functions are as follows:
|HAdd||Adds the record found in memory into the data file (query or view).|
|HAddGroup||Adds a group of users (HFSQL Client/Server connection)|
|HAddLink||Adds an integrity rule between two files on the server.|
|HAddUser||Adds a user (HFSQL Client/Server connection)|
|HStopServer||Stops an HFSQL server. To perform this action, the user must have sufficient rights on the server.|
|HChangeLogDir||Modifies the location of the log files corresponding to an HFSQL file. (*JNL file as well as JournalOpération and JournalIdentification files if they exist).|
|HCopyFile||Copies an HFSQL file from the client to the server (and conversely)|
|HCreation||Creates an empty data file (.FIC extension) with the index file and the memo file if necessary.|
|HCreationIfNotFound||The following operations are performed by HCreationIfNotFound:|
- If the file does not exist, creates an empty data file (".FIC" file) with the index file and the memo file if necessary.
The function is equivalent to HCreation.
- If the file exists, opens the file.
In this case, the function is equivalent to HOpen.
To optimize the call to HCreationIfNotFound, the file opening can also be performed during the first access to the file.
|HDBCreation||Ends the dynamic description of the file structure. The file that was just described is created on disk in the path specified in HDBDescribeFile. The data, memo and index files are created on disk.|
|HWrite||Writes a record into a data file without updating the indexes corresponding to all keys used in the file.|
|HImportHF55||Imports a Hyper File 5.5 file into an HFSQL Classic file.|
|HImportText||Imports a text file into a file in HFSQL Classic format.|
|HImportXML||Imports an XML file into a file in HFSQL Classic format.|
|HFree||Transforms the crossed records (HCross) into deleted records. The space occupied by the crossed records is freed and it can be re-used during the next additions (HAdd).|
|HMigrateLinkedCompositeKey||Migrates the values of the linked composite keys coming from a file in Hyper File 5.5 format to the HFSQL Classic format.|
|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 group on an HFSQL Client/Server data file.|
|HModifyServerRights||Modifies the rights granted to a user or to a group on a HFSQL server.|
|HModifyGroup||Modifies the information of the specified group according to the information of the structure.|
|HModifyDatabaseProperty||Modifies the properties of a database located on an HFSQL server.|
|HModifyFileProperty||Modifies the properties of an HFSQL file located on a server.|
|HModifyServerProperty||Modifies the properties of a HyperFileSQL server.|
|HModifyUser||Modifies the user information according to the structure information.|
|HCross||Crosses a file record. The record is deleted logically and it can be retrieved if necessary.|
|HRegenerateFile||Regenerates a file from its log.|
|HDelete||Deletes a record from a file (from a query or from a view).|
|HDeleteDatabase||Deletes a database located on an HFSQL server. All the connections that use the deleted database are closed.|
|HDeleteFile||Deletes the HFSQL files (.fic, .ndx and .mmo files if they exist) from the server.|
|HDeleteGroup||Deletes (from the server) a group of users associated with a connection.|
|HDeleteLink||Deletes an integrity rule between two files on the server.|
|HDeleteUser||Deletes (from the server) a user associated with a connection.|
|HViewToFile||Saves the modifications made to a view (by HModify, HDelete or HCross) in the corresponding file.|