|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Locks a record and restricts the access to this record for all the other applications. |
|
|
|
|
|
|
|
| Converts the content of the current record to string (in a data file, HFSQL view, query, etc.). |
|
|
|
|
|
|
|
| Changes the password of an HFSQL Classic or HFSQL Client/Server data file.... |
|
|
|
|
|
|
|
| Enables the filter that was previously created for the specified data file (view or query). |
|
|
|
|
|
|
|
| Enables an automatic filter on the linked files when browsing an XML file. |
|
|
|
|
|
|
|
| Modifies the physical name of a data file. |
|
|
|
|
|
|
|
| Add:
the record found in memory into the data file (query or view).
the record found in a Record variable into the data file (query or view).... |
|
|
|
|
|
|
|
| Creates a logical alias of a data file (or query) or cancels all existing aliases. |
|
|
|
|
|
|
|
| Cancels the current search criterion. |
|
|
|
|
|
|
|
| Used to associate a file with a binary memo item or to cancel the existing link between a file and a binary item. |
|
|
|
|
|
|
|
| Moves several records forward from the current position in the data file, according to a specified item. |
|
|
|
|
|
|
|
| Locks a data file and restricts the access to this data file for all other sites or applications. |
|
|
|
|
|
|
|
| Restores the context of a previously saved file (HSavePosition): current record, filter, pointers. |
|
|
|
|
|
|
|
| Dynamically changes the connection associated with a data file. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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, ...). |
|
|
|
|
|
|
|
| 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.... |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|