|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Deletes a previously created view. This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Builds the value of a composite key to implement a filter (HFilter) or to perform a search (HReadSeekFirst, HReadSeekLast, etc.). |
|
|
|
|
|
|
|
| Creates an empty data file (".FIC" extension) with the index file and the memo file if necessary. |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| Creates an HFSQL view.
This function uses the former view mechanism.... |
|
|
|
|
|
|
|
| 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).... |
|
|
|
|
|
|
|
| Declares a description of data file (found in an analysis) in the current project. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Compares two values by sorting them according to the specified HFSQL index item: all the sort options specified for the item are taken into account (sensitivity to the case, to the punctuation, sort direction, Unicode language, ...). |
|
|
|
|
|
|
|
| Duplicates the record read in a data file: the record found in memory is added into the data file (query or view). |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|