|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
| Allows you to:
Delete a declaration made previously using HDeclare, HDeclareExternal, HDescriveFile. After this operation, the data file is no longer recognized by the HFSQL engine.
Free the resources of a query (after calling HExecuteQuery or HExecuteSQLQuery).... |
|
|
|
|
|
|
|
| Locks a record and restricts the access to this record for all the other applications. |
|
|
|
|
|
|
|
| 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. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|