|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Defines and enables a "Contains" filter on a table, view or query. |
|
|
|
|
|
|
|
| Retrieves the structure and value of the current record and exports them into a string in JASON format. |
|
|
|
|
|
|
|
| Returns the list of synonyms used by a full-text index. |
|
|
|
|
|
|
|
| Adds comments to the log when saving the operation. |
|
|
|
|
|
|
|
| Executes an SQL query asynchronously. |
|
|
|
|
|
|
|
| Duplicates the record read in a table: the record found in memory is added into the table (query or view). |
|
|
|
|
|
|
|
| Cancels the current search criterion. |
|
|
|
|
|
|
|
| Runs a view that was created beforehand (can be used to refresh the view data for example). This function uses the former view mechanism. |
|
|
|
|
|
|
|
| Sets the position on the last record of a table according to a browse item. |
|
|
|
|
|
|
|
| Returns the list of full-text indexes of a file (a query or a view) recognized by the HFSQL engine. |
|
|
|
|
|
|
|
| Returns the number of entries for a given key item. |
|
|
|
|
|
|
|
| Executes a SELECT query asynchronously. |
|
|
|
|
|
|
|
| Compares two values by sorting them according to the specified HFSQL index sort item: all sort options specified for the sort item are taken into account (case sensitivity, punctuation, sort direction, Unicode language, ...). |
|
|
|
|
|
|
|
| Initializes:
one or all variables of file items with their default values.
one or all items of a Record variable with their default values.... |
|
|
|
|
|
|
|
| Defines the password used to create or open a table. |
|
|
|
|
|
|
|
| Restarts the logging process on a file. |
|
|
|
|
|
|
|
| Migrates the values of the linked composite keys coming from a file in Hyper File 5.5 format to the HFSQL Classic format. |
|
|
|
|
|
|
|
| Defines the mode for comparing tables. |
|
|
|
|
|
|
|
| Used to update the structure of an HFSQL table by performing an automatic data modification (also called data synchronization). |
|
|
|
|
|
|
|
| Stores the current context of a table: current record, filter, read pointers. |
|
|
|
|
|
|
|
| Checks that one or all records in an unalterable table have not been modified (e.g. with a hexadecimal editor). |
|
|
|
|
|
|
|
| Writes a record into a table without updating the indexes corresponding to all keys used in the table. |
|
|
|
|
|
|
|
| Imports JSON data into the current record. |
|
|
|
|
|
|
|
| Performs the following operations:
If the table doesn't exist, create an empty table (file with ".FIC" extension) with the index file, the full-text index file and the memo file if necessary. The function is equivalent to HCreation.
If the table exists, opens the table.... |
|
|
|
|
|
|
|
| Crosses a record in a table. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|