|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Duplicates the record read in a data file: the record found in memory is added into the data file (query or view). |
|
|
|
|
|
|
|
| Creates an HFSQL view.
This function uses the former view mechanism.... |
|
|
|
|
|
|
|
| Returns the date and time that an HFSQL record was last modified (Classic or Client/Server).... |
|
|
|
|
|
|
|
| Unlocks the records of a data file:
locked by HLockFile.
individually locked by a locking read function.... |
|
|
|
|
|
|
|
| Unlocks a record locked by:
HLockRecNum,
a read function used with a locking parameter (HRead associated with the hLockWrite or hLockReadWrite constant for example).... |
|
|
|
|
|
|
|
| Temporarily imports into the current analysis the description of a data file from an existing HFSQL data file. |
|
|
|
|
|
|
|
| Enables or disables the automatic security mechanism on one or more data files. |
|
|
|
|
|
|
|
| Sets the position on the last record of a data file according to a browse item. |
|
|
|
|
|
|
|
| Temporarily disables the filter on a data file (view or query). |
|
|
|
|
|
|
|
| Disables an automatic filter on the linked files when browsing an XML file. |
|
|
|
|
|
|
|
| Deletes a previously created view. This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Performs the following operations:
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.... |
|
|
|
|
|
|
|
| Describes a data file programmatically. |
|
|
|
|
|
|
|
| Writes a record into a data file without updating the indexes corresponding to all keys used in the file. |
|
|
|
|
|
|
|
| Retrieves the structure and the value of the current record and exports them into a character string in XML format. |
|
|
|
|
|
|
|
| Returns the status of a record during a modification conflict. |
|
|
|
|
|
|
|
| Determines:
whether a file exists, which means whether it was physically created (HCreation or HCreationIfNotFound).
whether a view or a query was defined.... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|