Home | Sign in | English EN
  • Overview
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Stored procedures
Reports & Queries: Unsupported WLanguage functions
Some WLanguage functions are not available in Reports & Queries. These functions are as follows:
HAddAdds the record found in memory into the data file (query or view).
HAddGroupAdds a group of users (HFSQL Client/Server connection)
HAddLinkAdds an integrity rule between two files on the server.
HAddUserAdds a user (HFSQL Client/Server connection)
HStopServerStops an HFSQL server. To perform this action, the user must have sufficient rights on the server.
HChangeLogDirModifies the location of the log files corresponding to an HFSQL file. (*JNL file as well as JournalOpération and JournalIdentification files if they exist).
HCopyFileCopies an HFSQL file from the client to the server (and conversely)
HCreationCreates an empty data file (.FIC extension) with the index file and the memo file if necessary.
HCreationIfNotFoundThe 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.
HDBCreationEnds 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.
HWriteWrites a record into a data file without updating the indexes corresponding to all keys used in the file.
HImportHF55Imports a Hyper File 5.5 file into an HFSQL Classic file.
HImportTextImports a text file into a file in HFSQL Classic format.
HImportXMLImports an XML file into a file in HFSQL Classic format.
HFreeTransforms 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).
HMigrateLinkedCompositeKeyMigrates the values of the linked composite keys coming from a file in Hyper File 5.5 format to the HFSQL Classic format.
HModifyModifies the specified record or the record found in memory in the data file (query or view).
HModifyDatabaseRightsModifies the rights granted to a user or to a group for a HFSQL Client/Server database.
HModifyFileRightsModifies the rights granted to a user or group on an HFSQL Client/Server data file.
HModifyServerRightsModifies the rights granted to a user or to a group on a HFSQL server.
HModifyGroupModifies the information of the specified group according to the information of the structure.
HModifyDatabasePropertyModifies the properties of a database located on an HFSQL server.
HModifyFilePropertyModifies the properties of an HFSQL file located on a server.
HModifyServerPropertyModifies the properties of a HyperFileSQL server.
HModifyUserModifies the user information according to the structure information.
HCrossCrosses a file record. The record is deleted logically and it can be retrieved if necessary.
HRegenerateFileRegenerates a file from its log.
HDeleteDeletes a record from a file (from a query or from a view).
HDeleteDatabaseDeletes a database located on an HFSQL server. All the connections that use the deleted database are closed.
HDeleteFileDeletes the HFSQL files (.fic, .ndx and .mmo files if they exist) from the server.
HDeleteGroupDeletes (from the server) a group of users associated with a connection.
HDeleteLinkDeletes an integrity rule between two files on the server.
HDeleteUserDeletes (from the server) a user associated with a connection.
HViewToFileSaves the modifications made to a view (by HModify, HDelete or HCross) in the corresponding file.
Minimum version required
  • Version 9
This page is also available for…
Click [Add] to post a comment