|
|
|
|
|
Reports & Queries software: WLanguage functions not supported
Some WLanguage functions are not available in Reports & Queries. These functions are as follows: | | HAdd | Adds the record found in memory to 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) | HChangeLogDir | Modifies the location of log files corresponding to an HFSQL data file. (*JNL file and JournalOperation and JournalIdentification files if they exist). | HCopyFile | Copy an HFSQL data file from the client to the server and vice versa | 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 calls to the HCreationSiInexistantfunction, the file can also be opened only when it is first accessed.
| HCross | Crosses a file record. The record is deleted logically and it can be retrieved if necessary. | HDBCreation | Ends the dynamic description of the file structure. The file that was just described is created on the disk in the path specified in HDBDescribeFile. The data, memo and index files are created on disk. | 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 HFSQL data files (.fic, .ndx and .mmo files if they exist) on 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. | 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 add operations (HAdd). | 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. | 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). | HModifyDatabaseProperty | Modifies the properties of a database located on an HFSQL server. | HModifyDatabaseRights | Sets the rights granted to a user or group for an HFSQL Client/Server database. | HModifyFileProperty | Modifies the properties of an HFSQL data file located on a server. | HModifyFileRights | Sets the rights granted to a user or group on an HFSQL Client/Server data file. | HModifyGroup | Modifies the information of the specified group according to the information of the structure. | HModifyServerProperty | Modifies the properties of an HFSQL server. | HModifyServerRights | Sets the rights granted to a user or group on an HFSQL server. | HModifyUser | Modifies the information of the specified user according to the information of the structure. | HRegenerateFile | Regenerates a file from its log. | HStopServer | Stops an HFSQL server. To perform this action, the user must have sufficient rights on the server. | HViewToFile | Saves the modifications made to a view (by HDelete, HModify or HCross) in the corresponding file. | HWrite | Writes a record into a data file without updating the indexes corresponding to all keys used in the file. |
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|