|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Returns the content of the current record (in a file, a view or a query, ...). |
|
|
|
|
|
|
|
| Imports an XML file into an HFSQL Classic or Client/Server data file (data file described in the data model editor or declared by HDeclare, HDeclareExternal or HDescribeFile).... |
|
|
|
|
|
|
|
| Migrates the values of the linked composite keys coming from a file in Hyper File 5.5 format to the HFSQL Classic format. |
|
|
|
|
|
|
|
| Returns:
the number of the current record in the HFSQL data file.
the number of the current record in the HFSQL view.... |
|
|
|
|
|
|
|
| Used to handle the idle periods of a software (period without processes) to optimize the queries and the browses that will be run thereafter. |
|
|
|
|
|
|
|
| Sets the position on a record, based on the approximate position of one of its items. |
|
|
|
|
|
|
|
| Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query. |
|
|
|
|
|
|
|
| Crosses a record in a data file. |
|
|
|
|
|
|
|
| Sets the position on the last file record whose value for a specific item is less than or equal to a sought value. |
|
|
|
|
|
|
|
| Positions on the first record of the data file whose value for a specific item is greater than or equal to a sought value (generic search by default). |
|
|
|
|
|
|
|
| Positions on the first file record whose value for a specific item is greater than or equal to a sought value. |
|
|
|
|
|
|
|
| Moves backward several records from the current position in the data file, according to a specified item. |
|
|
|
|
|
|
|
| Determines:
whether a file exists, which means whether it was physically created (HCreation or HCreationIfNotFound).
whether a view or a query was defined.... |
|
|
|
|
|
|
|
| Stores the current file context: current record, filter, pointers. |
|
|
|
|
|
|
|
| Performs various statistical calculations on the file keys. |
|
|
|
|
|
|
|
| Returns the date of the last update for the index statistics. |
|
|
|
|
|
|
|
| Returns the number of duplicates for a given key item. |
|
|
|
|
|
|
|
| Returns an estimate regarding the number of entries for a given key item in a given interval of values. |
|
|
|
|
|
|
|
| Returns the number of entries for a given key item. |
|
|
|
|
|
|
|
| Deletes all records from a data file, an HFSQL view or a query. |
|
|
|
|
|
|
|
| Transforms all "in transaction" records into "Normal" records if they do not belong to an ongoing transaction. |
|
|
|
|
|
|
|
| Defines the mode for comparing data files. |
|
|
|
|
|
|
|
| Used to find out:
whether the content of a file was modified.
whether the content of a file used by a query was modified.... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Retrieves the structure and value of the current record and exports them into a string in JASON format. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|