|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Builds the value of a composite key to implement a filter (HFilter) or to perform a search (HReadSeekFirst, HReadSeekLast, etc.). |
|
|
|
|
|
|
|
| Returns the list of items in a data file (query or view) recognized by the HFSQL engine. The data files defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account. |
|
|
|
|
|
|
|
| Returns the list of keys found in a file (query or view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Returns True if all the elements of an array are False. |
|
|
|
|
|
|
|
| Returns True if all the elements of an array are True. |
|
|
|
|
|
|
|
| Returns True if at least one element of an array is False. |
|
|
|
|
|
|
|
| Returns True if at least one element of an array is True. |
|
|
|
|
|
|
|
| Modifies the search mode of physical data files (.FIC, .NDX, ...). |
|
|
|
|
|
|
|
| Transforms the crossed records (HCross) into deleted records. |
|
|
|
|
|
|
|
| Changes the path to a data file (i.e. directory in which the file will be handled). |
|
|
|
|
|
|
|
| Modifies the location of log files corresponding to an HFSQL data 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, ...). |
|
|
|
|
|
|
|
| Dynamically changes the connection associated with a data file. |
|
|
|
|
|
|
|
| Copies:
the content of the current record (loaded in memory) to the current data file record.
the content of the Record variable to the current data file record.... |
|
|
|
|
|
|
|
| Creates an empty data file (".FIC" extension) with the index file and the memo file if necessary. |
|
|
|
|
|
|
|
| Returns the date and time that an HFSQL record was last modified (Classic or Client/Server).... |
|
|
|
|
|
|
|
| Declares a description of data file (found in an analysis) in the current project. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|